Merging Gridview data into Gridview

See more:

C#

ASP.NET

SQL-Server

Dear Friends,

I am displaying Team 1 Members in the list in first gridview with a check box.
And i also displaying Team 2 Members in second gridview with check box.
The two gridviews retrieves the data from query.

Now when I select the names from Grid 1 and 2, it should add in third gridview.
Now I have coded as - for each selection it executes the query and retieves the data.
But is there any provision to add the selected list in 3rd grid without refering the Table