How do I dynamically populate a gridview based on the selected row of another gridview?
Suppose I have a e-shop web app. I have a product categories table in my database that populates a gridview using sqldatasource.

I want to be able to click on the select hyperlink on a row and use that event to populate ANOTHER gridview based on the ID of the product category that is clicked. E.g say the 'CDs' row is clicked, another gridview shows all the different CDs.

As a result, I need the select(sql) statement for the second table to be dynamic based on what the user clicks.

Has anyone done anything like this before?



Any help would be greatly appreciated,

Mark
How do I dynamically populate a gridview based on the selected row of another gridview?
===

Suppose I have a e-shop web app. I have a product categories table in my database that populates a gridview using sqldatasource.

I want to be able to click on the select hyperlink on a row and use that event to populate ANOTHER gridview based on the ID of the product category that is clicked. E.g say the 'CDs' row is clicked, another gridview shows all the different CDs.

As a result, I need the select(sql) statement for the second table to be dynamic based on what the user clicks.

Has anyone done anything like this before?



Any help would be greatly appreciated,

Mark