Hi,
   i have created a simple dataset and want another
   independent copy. How can I clone dataset1 to dataset2 ???
   ( ie ending up with 2 separate copies that I can do
    manipulate separately).

   I want to avoid having to re-query a database to get the
   same data into a different dataset.

cheers muchly
chas.

Hello,
in this regard there are two methods for DataSet objects,
1-Clone
yourNewDataSet=yourDataSet.Clone();
Clones the structure of the DataSet, including all DataTable schemas, relations, and constraints.
2-Copy
yourNewDataSet=yourDataSet.Copy();
Copies both the structure and data for this DataSet,
HtH.

--------------------------------------------
Mehdi.:)