S
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!
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!