Show Data in GridView

hi Tom,

there are many way to show data in grid view from two or more table..

you can also write combine query using join and union that return result that you want.
you can also create data relation between datatable.

please refer..

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataset/thread/f63f612f-20be-4bad-a91c-474396941800
http://msdn.microsoft.com/en-us/library/0k21zcyx%28v=vs.71%29.aspx

hope this will help you.

To display data from 2 or more tables, first thing is to have same column or data to be displayed in the grid from all the tables. So, you should be binding the data with same columns.

There are many ways to merge the data into one source. If you have multiple data sets, you can merge them into one using syntax dataset1.Merge(dataset2).

Otherwise, you can loop through the datatable's data rows and add the data into one of the datatables and bind the datatable data to the gridview.

Let me know what is your requirement with more details so that I may help you out with more accurate info.