DataRelations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've verified multiple times that a column exists named FILESTRING in a table
named VIRTUALTOURS. However, I keep getting the following error:

FileString is neither a DataColumn nor a DataRelation for table floorplans.

I have a nested repeater. Without the nested repeater the main repeater
displays data fine. The nested repeaters datasource is a DataRelation. Here
is the HTML code for the nested repeater or child repeater.

<asp:Repeater ID="rptChild" DataSource='<%#
Container.DataItem.Row.GetChildRows("myrelation") %>'>
<ItemTemplate>
<asp:LinkButton id="VirtualLinks" runat="server" CommandName="Open"
CommandArgument='GoodBye'><%#
Container.DataItem("FileString")></asp:LinkButton> <br>
</ItemTemplate>
</asp:Repeater>

Here is my Load event:

Dim myAuthenticate As New myAuth
Dim myConn As New
MySql.Data.MySqlClient.MySqlConnection(myAuthenticate.DecryptConnectionString)
Dim cmd1 As New MySql.data.MySqlClient.MySqlDataAdapter("select *
from floorplans where virtualtours = 'y'", myConn)
Dim ds As DataSet = New DataSet
cmd1.Fill(ds, "floorplans")

Dim cmd2 As New MySql.Data.MySqlClient.MySqlDataAdapter("select *
from virtualtours", myConn)
cmd2.Fill(ds, "virtualtours")
ds.Relations.Add("myrelation",
ds.Tables("floorplans").Columns("planid"),
ds.Tables("virtualtours").Columns("planid"))
rptTours.DataSource = ds.Tables("floorplans")
Page.DataBind()
myConn.Close()
 
Back
Top