dataview
-
I am trying to set a data relation and I keep getting an error saying: The relation is not parented to the table to which this DataView points. What does this mean. Here is the vb.net code that im using: <%@ Import Namespace="System.Data.Odbc" %> <%@ Import Namespace="System.Data" %> sub Page_Load Dim sConnString As String = "Dsn=mysqldb;" & _ "Uid=bigtone78;" & _ "Pwd=" Dim oODBCConnection As New OdbcConnection(sConnString) Dim myInsertQuery As String = "SELECT * FROM questions" Dim cmd1 As odbcdataAdapter = New odbcdataAdapter(myInsertQuery, oODBCConnection) Dim ds As DataSet = New DataSet() cmd1.Fill(ds, "questions") Dim sqlQuery as String = "select * from options" Dim cmd2 As odbcdataAdapter = New odbcdataAdapter(sqlQuery, oODBCConnection) cmd2.Fill(ds, "options") ds.Relations.Add(new DataRelation("myrelation", ds.Tables("questions").Columns("id"), ds.Tables("options").Columns("qID"))) questions.DataSource= ds.Tables("questions") questions.DataBind() oODBCConnection.close() end sub sub questions_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) if e.item.itemtype = ListItemType.Item or e.item.ItemType = ListItemType.AlternatingItem then Dim dv as DataRowView = e.Item.DataItem if not dv is nothing then Dim nestedRepeater as Repeater = e.item.FindControl("opts") if Not nestedrepeater Is Nothing then nestedRepeater.DataSource = dv.CreateChildView("options") nestedRepeater.DataBind() end if end if end if response.write("<br />") end sub
-
I am trying to set a data relation and I keep getting an error saying: The relation is not parented to the table to which this DataView points. What does this mean. Here is the vb.net code that im using: <%@ Import Namespace="System.Data.Odbc" %> <%@ Import Namespace="System.Data" %> sub Page_Load Dim sConnString As String = "Dsn=mysqldb;" & _ "Uid=bigtone78;" & _ "Pwd=" Dim oODBCConnection As New OdbcConnection(sConnString) Dim myInsertQuery As String = "SELECT * FROM questions" Dim cmd1 As odbcdataAdapter = New odbcdataAdapter(myInsertQuery, oODBCConnection) Dim ds As DataSet = New DataSet() cmd1.Fill(ds, "questions") Dim sqlQuery as String = "select * from options" Dim cmd2 As odbcdataAdapter = New odbcdataAdapter(sqlQuery, oODBCConnection) cmd2.Fill(ds, "options") ds.Relations.Add(new DataRelation("myrelation", ds.Tables("questions").Columns("id"), ds.Tables("options").Columns("qID"))) questions.DataSource= ds.Tables("questions") questions.DataBind() oODBCConnection.close() end sub sub questions_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) if e.item.itemtype = ListItemType.Item or e.item.ItemType = ListItemType.AlternatingItem then Dim dv as DataRowView = e.Item.DataItem if not dv is nothing then Dim nestedRepeater as Repeater = e.item.FindControl("opts") if Not nestedrepeater Is Nothing then nestedRepeater.DataSource = dv.CreateChildView("options") nestedRepeater.DataBind() end if end if end if response.write("<br />") end sub