DataGridView for several tabels in a DataSet

  • Thread starter Thread starter atally12
  • Start date Start date
A

atally12

I have a DataSet with two tables in it, with a relation between them.
I fill the tables with records programmatically with these commands:
System.Data.DataRow newRow = myTable.NewRow();
//give values to each column in the row
myTable.Rows.Add(newRow);
I want to create a DataGridView that is bounded to this dataset and
show in each row columns from both tables.
But when I set the DataSource of the DataViewGrid to the DataSet, I
can only pick one table from the DataSet as the DataMember. And then I
can only choose columns from that specific table.
I tried setting the relation as the DataMember - but it seems the
relations only has columns from one of that tables and I couldn't find
how to change that.

Is there a way to "join" the columns of the two tables into one
DataGridView?

Thanks
 
Back
Top