Populates GridView2 based on selected row from GridView1

[PetroTiburcio]

Greetings! Help with gridviews. I have 2 gridview on my page: on GridView1 I have a column with select link, Id and Name which looks like this:

Select | Id | Name
select | 101 | Jack
select | 102 | Cath

Now, what I am trying to do is let's say, i clicked the select from the first row which is Jack, now my GridView2 will display the products ordered by Jack which looks like this:

Id | ProductID
101 | 111
101 | 222
101 | 333

and if Cath whom I selected, GridView2 will change the display products which ordered by Cath:

Id | productID
102 | 111
102 | 333
102 | 555

In short, I am trying to populate GridView2 based on the selected row from the GridView1. I am using asp.net with c#. Kindly help me with this, thank you very much in advance. God bless :)

[Frinavale]

You can handle the GridView's SelectedIndexChanged event.

In that event, retrieve the ID of the person selected, execute your query to retrieve product orders for that person, set the DataSource of GridView2 to the data retrieved from the database and then call the DataBind method on GridView2.

-Frinny