Hi Guys
I have the following code which works how I want it to except that I am unable to hide / display information based on the results from the nested repeater.
'The Following Code Will Nest 2 Repeater Tags To Diplay The Area And The Properties Within Them
Dim DBConnection As SqlConnection = New SqlConnection(GlobalParameters.DBConnection())
Dim DataAdapter As SqlDataAdapter = New SqlDataAdapter("EXEC DSP_WListApartments", DBConnection)
Dim DataSet As DataSet = New DataSet()
DataAdapter.Fill(DataSet, "ListApartments")
Dim DataAdapter2 As SqlDataAdapter = New SqlDataAdapter("EXEC DSP_WListApartmentPropertyByArea", DBConnection)
DataAdapter2.Fill(DataSet, "ApartmentByArea")
DataSet.Relations.Add("ApartmentByAreaRelationship", DataSet.Tables("ListApartments").Columns("Area_Id"), DataSet.Tables("ApartmentByArea").Columns("Property_Area_Id"))
ListApartments.DataSource = DataSet.Tables("ListApartments")
Page.DataBind()
DBConnection.Close()
Any ideas?
Kind regards
I have the following code which works how I want it to except that I am unable to hide / display information based on the results from the nested repeater.
'The Following Code Will Nest 2 Repeater Tags To Diplay The Area And The Properties Within Them
Dim DBConnection As SqlConnection = New SqlConnection(GlobalParameters.DBConnection())
Dim DataAdapter As SqlDataAdapter = New SqlDataAdapter("EXEC DSP_WListApartments", DBConnection)
Dim DataSet As DataSet = New DataSet()
DataAdapter.Fill(DataSet, "ListApartments")
Dim DataAdapter2 As SqlDataAdapter = New SqlDataAdapter("EXEC DSP_WListApartmentPropertyByArea", DBConnection)
DataAdapter2.Fill(DataSet, "ApartmentByArea")
DataSet.Relations.Add("ApartmentByAreaRelationship", DataSet.Tables("ListApartments").Columns("Area_Id"), DataSet.Tables("ApartmentByArea").Columns("Property_Area_Id"))
ListApartments.DataSource = DataSet.Tables("ListApartments")
Page.DataBind()
DBConnection.Close()
Any ideas?
Kind regards