rgavrilov
asked on
Show results from multiple DataTable in one DataGridView
I have a typed DataSet that contains two tables, related through key:
Table: People
ID FirstName LastName CompanyID
Table: Companies
ID Name
Key: People.ID -> Companies.ID
Note: DataSet is loaded from XML file, i.e. there is no database.
Problem:
I want to show data table (using DataGridView) with following columns:
First Name | Last Name | Company Name
What are my options?
Should I have a database, I could run an SQL query and show the results, but I don't have a database.
Table: People
ID FirstName LastName CompanyID
Table: Companies
ID Name
Key: People.ID -> Companies.ID
Note: DataSet is loaded from XML file, i.e. there is no database.
Problem:
I want to show data table (using DataGridView) with following columns:
First Name | Last Name | Company Name
What are my options?
Should I have a database, I could run an SQL query and show the results, but I don't have a database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Umut Şeker
Sorry all DataSet2's must be DataSet1.