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("myDataSet")

'Load 3 tables with data from my DB
Dim tblEmployees As DataTable = FetchEmployeeData() 'Table name =
"Employees"
Dim tblEmployeeDetails As DataTable = FetchEmployeeDetailsData()
'Table name = "EmployeeDetails"
Dim tblTasks As DataTable = FetchTaskData() 'Table name = "Tasks"

ds.Tables.Add(tblEmployees)
ds.Tables.Add(tblEmployeeDetails)
ds.Tables.Add(tblTasks)

Dim str() As String
'Infer a schema that define the relations between tables based on the
EmployeeSchemaPath constant value
ds.InferXmlSchema(EmployeeSchemaPath, 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.com> schreef in bericht
news:11**********************@g49g2000cwa.googlegr oups.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("myDataSet")

'Load 3 tables with data from my DB
Dim tblEmployees As DataTable = FetchEmployeeData() 'Table name =
"Employees"
Dim tblEmployeeDetails As DataTable = FetchEmployeeDetailsData()
'Table name = "EmployeeDetails"
Dim tblTasks As DataTable = FetchTaskData() 'Table name = "Tasks"

ds.Tables.Add(tblEmployees)
ds.Tables.Add(tblEmployeeDetails)
ds.Tables.Add(tblTasks)

Dim str() As String
'Infer a schema that define the relations between tables based on the
EmployeeSchemaPath constant value
ds.InferXmlSchema(EmployeeSchemaPath, 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!