how to copy dataset?

Hi all,

I have 2 datasets, how to copy all tables and data from dataset1 to dataset2?

I m using:

Rows.Add(Rows[ n ].ItemArray);

but i found it's too slow..

is there any better solution? thanks

Hi there,

I believe that the Dataset class has a Copy() function which you can use. It returns a new Dataset and apparently it copies all the tables and data.

Here's a link to the relevant portion of MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatasetclasscopytopic.asp

No MSDN2 I'm afraid, it seems to be dying on me at the moment.

Hope that helps a bit, but sorry if it doesn't