Select statement on Dataset problems!! :-(

[soulcode]

Hi Guys,

Yesterday i was playing around with some code where I would read an xml
file into a dataset...

'***********************************
Dim ds as dataset

ds.readxml("test.xml")
'***********************************

with the data in the dataset, i want to be able to select all rows where
ParentID = 0...

'***********************************
Dim rows1 as datarow() = ds.tables(0).select("ParentID = '0'")
'***********************************

My question is, how do I convert that datarows (in rows1) into a dataset
from here? or is there a way to apply a sql select statement over the
ds dataset what returns a dataset?


you help would be much appreciated.

 

[Scott Allen]

There is no built in method to do this, but take a look at :

HOW TO: Implement a DataSet SELECT INTO Helper Class in Visual Basic
..NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;325684

Which should get you most of the way there.

HTH,

 

[soulcode]

Thanks guys... you've both helped me out greatly!!