Nested Repeaters
I have the following code that I am using for nested repeaters. The code runs as I want it to but I am unable to access data from the nested repeater. Any Ideas on how to do this?
Dim DBConnection As SqlConnection = New SqlConnection(GlobalParameters.DBConnection())
Dim DataAdapter As SqlDataAdapter = New SqlDataAdapter("EXEC DSP_WListFarmhouses", DBConnection)
Dim DataSet As DataSet = New DataSet()
DataAdapter.Fill(DataSet, "ListFarmhouses")
Dim DataAdapter2 As SqlDataAdapter = New SqlDataAdapter("EXEC DSP_WListFarmhousePropertyByArea", DBConnection)
DataAdapter2.Fill(DataSet, "FarmhouseByArea")
DataSet.Relations.Add("FarmhouseByAreaRelationship ", DataSet.Tables("ListFarmhouses").Columns("Area_Id" ), DataSet.Tables("FarmhouseByArea").Columns("Propert y_Area_Id"))
ListFarmhouses.DataSource = DataSet.Tables("ListFarmhouses")
Page.DataBind()
DBConnection.Close()
|