How to Spit Dataset

[Niraj Ranka]

Hello,

Can anyone please let me know, how can i split the dataset into two
datasets... based on some condition.

Thanx in advance
Niraj Ranka

 

[Cor Ligthert]

Niraj,

A dataset is basicly only an object that holds tables and relations between
them.

So maybe you can tell what you want to split?

Cor

 

[Niraj Ranka]

Hello,

Actually i have data from table based on groupid as 1 and 2, now i want to
bifercate the data in two datasets, one containing the data where groupid is
1 and second containing the data where groupid is 2.

Hope this will clear the picture.

Niraj A Ranka

 

[Cor Ligthert]

Niraj,

I think that I would do it like this,

Create a new dataset

create a new datatable
Clone the datatable to that

http://msdn.microsoft.com/library/d...l/frlrfsystemdatadatatableclassclonetopic.asp

add that cloned datatable to the new dataset
ds.tables.add(table)

Make a reverse for index loop in the first datatable where in one time, the
datarow is imported with importrow in the result datatable and delete (maybe
in this case better remove, what depends what you want to do later with it)
in the sending datatable

http://msdn.microsoft.com/library/d...lrfsystemdatadatatableclassimportrowtopic.asp

That is all.

I hope this helps?

Cor