Assume that we have two tables with the following structure:
Table1
Field1 int
Field2 varchar(5)
Field3 varchar(10)
Table2
Field1 int
Field2 varchar(5)
Field3 varchar(10)
we need a datagrid to display records from the above tables
Check the code in the link
http://www.zowaar.net/forum/showthread.php?254-Merging-two-Datasets-into-a-single-Datagrid