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

Hi,

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

Ken
-----------------------
"Alan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

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)
///