By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,344 Members | 1,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,344 IT Pros & Developers. It's quick & easy.

DataSet SubQuery

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 20 '05 #2

P: n/a
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)
///
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.