Hello,
Does anyone know how to Dynamically populate a 2nd dropdown based on the values of the 1st dropdown, then display the results in the Gridview? I have done the easy part of populating the 1st dropdown with the database and i can display those records, now i need to filter my records with the 2nd dropdown.
thank you

Enable auto postback for the first drop down, and then in the page_load you can check if the page is post_backed (if page.ispostback() then...) then you should use the first drop down's selectedvalue as the parameter in the second drop down list. You can select this parameters, when designing the query for the SQLDataSource control itself in the "where..." button option.

Otherwise as mentioned above i was talking about page_load, you can use the Second drop down list data control's selectcommand to be specified ussing the first drop downlist's value
Something like this
SecondDataSource.SelectCommand = "Select * from SecondTable where fieldname = " & firstdropdownlist.selectedvalue

What this will do is change the datasource for the second drop down list as SecondDataSource is associated with the second drop down list. Then similarly you can work on a logic for the gridview in the same fashion as the earlier one.


Vincent Thomas
Bangalore