Working with datasets

[Nijazi Halimaji]

Hi newsgroup

I have allready posted this problem, but in german... So I try again in
english

I have a little logical problem with dataset.


I have a main dataset which includes all data.

After working with the data I have an array which includes the key values of
a column in my dataset.

Now I like to store all rows which key value is in the array into another
dataset and delete those rows from the main dataset.

Finally i should have 2 datasets.


How to do in a simple way?

Thanks alot

Nijazi Halimaji

 

[Sahil Malik [MVP]]

Nijazi,

You can use DataTable.Select to find the relevant rows that match your
criteria, and then use DataRowCollection.Remove to remove them from one
DataTable, and subsequently DataTable.Rows.Add to add it in the other.


- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx