DataSet Table Join

[Dragon]

Can I Join two Data Table in Data set ??
Is it using the DataSet.Merge ?

Any example ?

[Michael Nemtsev]

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

[Dragon]

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

[Michael Nemtsev]

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