Select statement on Dataset problems!! :-(

  • Thread starter Thread starter soulcode
  • Start date Start date
S

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.
 
Back
Top