How to merge 2 different server's database into one datagrid

[nokomoli]

hello guy,

Recently i faced a problem that i have 2 sqldatasource where connect to different server. But the problem is how to combine 2 sqlcommand into one datagrid.
eg:

1) sql1 = Select ID, Name from Table1

 sqldatasource1.selectcommand = sql1
datagrid1.datasource = sqldatasource1
datagrid1.databind

2) sql2 = Select ID, Name from Table2

 sqldatasource2.selectcommand = sql2
datagrid2.datasource = sqldatasource2
datagrid2.databind

SO, How i merge 2 datagrid into 1 datagrid?

[Ramy Mahrous]

DateSet.Merge(AnotherDataSet) Read in merging datasets on http://msdn.microsoft.com/en-us/library/4swwh51k.aspx
An example http://aspalliance.com/148