Question How to databind multiple datatables into one Gridview?

[raysefo]

Hi,

I have different tables, but they all have 3 same fields. I want to display those same fileds in a gridview.Is it possible to have multiple datatables into a gridview?

Lets say;

Table1 ---> id name surname samefield1 samefield2 samefield3
Table2----> id name surname samefield1 samefield2 samefield3

I want to display those same fields in a gridview.

Gridview;

samefield1 samefield2 samefield3---> table1
samefield1 samefield2 samefield3 ---> table2

Best Regards

 

[kulrom]

SQL UNION Operator

 

[raysefo]

I did it exactly the way it tells thanks so much