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?