Show results from multiple DataTable in one DataGridView
Posted on 2007-04-04
I have a typed DataSet that contains two tables, related through key:
ID FirstName LastName CompanyID
Key: People.ID -> Companies.ID
Note: DataSet is loaded from XML file, i.e. there is no database.
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.