I'm currently populating a hierarchical radgrid with two SqlDataSources (one for my MasterTableView and the other for my
DetailsView). I have the values of my DataKeyNames MasterKeyFIeld, DataKeyFiled all matching. Initially the page works as
expected. In addition, I have a few dropdownlists on the page that I would like to re-arrange the data on my grid by soon after
the user clicks a button. Once the user chooses the desired options from the dropdownlists and clicks the button, through codebehind
I'm changing the SelectCommand of the sqlDataSource and doing a RadGrid1.DataBind() on both DataSources.
my code in my vb page looks something like this:
SqlDataSource1.SelectCommand = "Command"
RadGrid1.DataBind()
SqlDataSource2.SelectCommand = "Command"
RadGrid1.DataBind()
After the button click, The MasterTableView applies the new SqldataSource that I set in codebehind(SqlDataSource1), however, my DetailsView still contains the information from my initial SqlDataSource2 Select Statement. I need that Data to be populated as well.
Any help/suggestions i would really appreciate, thank you
DetailsView). I have the values of my DataKeyNames MasterKeyFIeld, DataKeyFiled all matching. Initially the page works as
expected. In addition, I have a few dropdownlists on the page that I would like to re-arrange the data on my grid by soon after
the user clicks a button. Once the user chooses the desired options from the dropdownlists and clicks the button, through codebehind
I'm changing the SelectCommand of the sqlDataSource and doing a RadGrid1.DataBind() on both DataSources.
my code in my vb page looks something like this:
SqlDataSource1.SelectCommand = "Command"
RadGrid1.DataBind()
SqlDataSource2.SelectCommand = "Command"
RadGrid1.DataBind()
After the button click, The MasterTableView applies the new SqldataSource that I set in codebehind(SqlDataSource1), however, my DetailsView still contains the information from my initial SqlDataSource2 Select Statement. I need that Data to be populated as well.
Any help/suggestions i would really appreciate, thank you