Combing Multiple datasets to one to bind to a datagrid

[jcash35010]

Anyone with any ideas? I have several datasets that all have the same columns, but different data. I need to combine these all into one dataset to be able to bind them to one datagrid. I know I could query the database for just one datagrid, but I am not able to in this case. I have to query the database for each one separately.

Any help would be greatly appreciated!!!

 

[stnkyminky]

You will need to do something like the following. Fill the SAME table in the dataset after each query. When you are finished querying the database, dataset will contain all the data.

DataAdapter.SelectCommand = "Select * from Table1"
DataAdapter.Fill(dataset,"Data&quot

DataAdapter.SelectCommand = "Select * from Table2"
DataAdapter.Fill(dataset,"Data&quot

DataAdapter.SelectCommand = "Select * from Table3"
DataAdapter.Fill(dataset,"Data&quot

Scott
Programmer Analyst
<{{><