DataGridView for several tabels in a DataSet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top