DataSet SubQuery

[Alan]

Dear all,

Can I use the Dataset to create two datasets, a one dataset result is based
on the other dataset, like the subqurey?

can you give me some example?

Thanks

Regards,

Alan

[Ken Tucker [MVP]]

Hi,

Take a look at the datatable.select method.
http://msdn.microsoft.com/library/de...electtopic.asp

Ken
-----------------------
"Alan" <sa********@hotmail.com> wrote in message
news:eV**************@TK2MSFTNGP10.phx.gbl...

Dear all,

Can I use the Dataset to create two datasets, a one dataset result is
based
on the other dataset, like the subqurey?

can you give me some example?

Thanks

Regards,

Alan

[Cor Ligthert]

Hi Alan,

Yesterday I did send this sample, I think you can use that (I changed it a
little bit in this message to let it fit more to your needs so watch typos).

I hope this helps?

Cor
\\\
Dim dv As New DataView(dt.tables(0))
dv.Sort = "bla"
dv.rowfilter = "MyField = 1"
Dim dtnew As DataTable = dt.tables(0).Clone
For Each dvr As DataRowView In dv
dtnew.ImportRow(dvr.Row)
Next
dt.tables.add(dtnew)
///