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

DataSet Table Join

P: n/a
Can I Join two Data Table in Data set ??
Is it using the DataSet.Merge ?

Any example ?
Mar 7 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hello Dragon,

Sample is in MSDN http://msdn.microsoft.com/library/de...ergetopic3.asp

D> Can I Join two Data Table in Data set ??
D> Is it using the DataSet.Merge ?
D> Any example ?
D>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Mar 7 '06 #2

P: n/a
The Examples seems to be adding row below the table

Actually I want Employee Table join with Employee Order Table in Dataset.
Say EmployeeTable
ID Name
1 ABC
2 CDE
EmployeeOrder Table
ID ItemNo
1 101
1 102
2 103

I want a returen Dataset like this:
ID Name ItemNo
1 ABC 101
1 ABC 102
2 CDE 103

Thx.
"Michael Nemtsev" <ne*****@msn.com> wrote in message
news:9c**************************@msnews.microsoft .com...
Hello Dragon,

Sample is in MSDN
http://msdn.microsoft.com/library/de...ergetopic3.asp

D> Can I Join two Data Table in Data set ??
D> Is it using the DataSet.Merge ?
D> Any example ?
D> ---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do
not cease to be insipid." (c) Friedrich Nietzsche

Mar 7 '06 #3

P: n/a
Hello Dragon,

For that way iterate DataRows manually and add new column with items to the
destination dataTable

D> The Examples seems to be adding row below the table
D>
D> Actually I want Employee Table join with Employee Order Table in
D> Dataset.
D> Say EmployeeTable
D> ID Name
D> 1 ABC
D> 2 CDE
D> EmployeeOrder Table
D> ID ItemNo
D> 1 101
D> 1 102
D> 2 103
D> I want a returen Dataset like this:
D> ID Name ItemNo
D> 1 ABC 101
D> 1 ABC 102
D> 2 CDE 103
D> Thx.
D>
D> "Michael Nemtsev" <ne*****@msn.com> wrote in message
D> news:9c**************************@msnews.microsoft .com...
D>
Hello Dragon,

Sample is in MSDN
http://msdn.microsoft.com/library/de...ary/en-us/cpre
f/html/frlrfsystemdatadatasetclassmergetopic3.asp

D> Can I Join two Data Table in Data set ??
D> Is it using the DataSet.Merge ?
D> Any example ?
D> ---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour
"At times one remains faithful to a cause only because its opponents
do not cease to be insipid." (c) Friedrich Nietzsche

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Mar 7 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.