whizkid123 Posted January 10, 2003 Posted January 10, 2003 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 it's disable always. I dunno how do i enable it. Thanx 4 ur help! (merge does not help) Quote
*Experts* Bucky Posted January 10, 2003 *Experts* Posted January 10, 2003 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. Quote "Being grown up isn't half as fun as growing up These are the best days of our lives" -The Ataris, In This Diary
*Experts* Nerseus Posted January 10, 2003 *Experts* Posted January 10, 2003 Or use the Merge method of one DataSet to merge the other one. You can merge DataSets, tables or rows. -Nerseus Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.