Query results from multiple table dataset

[Stef]

Hi people,
I'd like to know if it's possible to get DataRows containing data
from different tables that are part of one single dataset?

Example:

Dim ds As New DataSet("myData Set")

'Load 3 tables with data from my DB
Dim tblEmployees As DataTable = FetchEmployeeDa ta() 'Table name =
"Employees"
Dim tblEmployeeDeta ils As DataTable = FetchEmployeeDe tailsData()
'Table name = "EmployeeDetail s"
Dim tblTasks As DataTable = FetchTaskData() 'Table name = "Tasks"

ds.Tables.Add(t blEmployees)
ds.Tables.Add(t blEmployeeDetai ls)
ds.Tables.Add(t blTasks)

Dim str() As String
'Infer a schema that define the relations between tables based on the
EmployeeSchemaP ath constant value
ds.InferXmlSche ma(EmployeeSche maPath, str)

ds.Select(???) ?
Am I on the right path?

Any suggestions?

Thanks a lot for reading!

[Pipo]

There is also a merge property...

"Stef" <st************ @mittalsteel.co m> schreef in bericht
news:11******** **************@ g49g2000cwa.goo glegroups.com.. .

Hi people,
I'd like to know if it's possible to get DataRows containing data
from different tables that are part of one single dataset?

Example:

Dim ds As New DataSet("myData Set")

'Load 3 tables with data from my DB
Dim tblEmployees As DataTable = FetchEmployeeDa ta() 'Table name =
"Employees"
Dim tblEmployeeDeta ils As DataTable = FetchEmployeeDe tailsData()
'Table name = "EmployeeDetail s"
Dim tblTasks As DataTable = FetchTaskData() 'Table name = "Tasks"

ds.Tables.Add(t blEmployees)
ds.Tables.Add(t blEmployeeDetai ls)
ds.Tables.Add(t blTasks)

Dim str() As String
'Infer a schema that define the relations between tables based on the
EmployeeSchemaP ath constant value
ds.InferXmlSche ma(EmployeeSche maPath, str)

ds.Select(???) ?
Am I on the right path?

Any suggestions?

Thanks a lot for reading!

[Stef]

Pipo,
thank you for your quick answer.
Unfortunately, I don't see how .Merge can help in my situation because
I want to grab data from an employee and extract everything related to
him so I can fill a grid with those values or else, create an instance
of an employee class I made, etc...

Maybe I'm missing something?

If you still believe .Merge is the way to go, can you provide me with
an example?
I have checked MSDN examples about .Merge and tried some things but it
doesn't look like it's a solution that fits well my needs...

Thanks!