How to marge GridView1 GridView2 and GridView3 common Rows

Question

I have three GridViews but those have one common cell on the basis of that i want to join rows of three GridViews. Any one help me for this problem

Mohammad Aman · Answer

thnx.. but it is SQL query ... i am want solution for asp.net gridviews as i m attaching screenshot.

Srikanth Reddy · Answer

SELECT column1 FROM table1 INTERSECT SELECT column1 FROM table2 INTERSECT SELECT column1 FROM table3 Provides the common data from table1  table2 and table3. get the data and bind to gridview. If still doubts feel free to ask.

Mohammad Aman · Answer

any other method to do this.

Srikanth Reddy · Answer

Sorry no demo link But just try to use joins concept and retrieve the common data from 3 tables and bind the result to another table. It can be done.

Mohammad Aman · Answer

Can you give me demo link for this;

Srikanth Reddy · Answer

Use joins concept on the three tables and filter the records. Bind the result to another gridview.

How to marge GridView1, GridView2 and GridView3 common Rows