appending records from one dataset to another

[whizkid123]

Hi! How do you concatenate two datasets? I have created on dataset with a particular query. Now I need to append the results of another query into the same dataset. This is needed so that I can create an XML file from that dataset. I have tried to use the component designer but its disable always. I dunno how do i enable it. Thanx 4 ur help! (merge does not help)

 

[Bucky]

If the rows are in a DataTable, you can use its Clone method to
create a copy of the table. Then add this copy to the other
DataSet.

If you want all the rows to be in one table, then simply loop
through all the rows and Clone each one, then add it to the other
table.

 

[Nerseus]

Or use the Merge method of one DataSet to merge the other one. You can merge DataSets, tables or rows.

-Nerseus