Fill a DataGridView with data from 2 related tables

[aecordoba]

Hi, there! I have two related tables in a DataSet and I want to fill a DataGridView with data from both tables. Could anybody tell me an easy way to do it? Thank you, in advance.

-- Adrián Córdoba

[RepliCrux]

1. You can create a third table and insert the required data in that table and then bind the datasource to that table. 2. Or you can write a store procedure which will just get those data and return select.

[I explore code]

You can create a third data table (dt3) at runtime in the same dataset (ds), populate it with the fields from the two data tables(dt1 and dt2) and then finally bind this data table with the grid view using its data source property as shown below (but this solution is effective only if there will be same number and type of fields everytime you create and populate a new data table): dataGridView1.DataSource=ds.Tables["dt3"]; This should solve your problem

[aecordoba]

Thank you! I'll try that way.

-- Adrián Córdoba

[aecordoba]

Hi, fellows! When I was trying the solutions you recommended to me, I found a third way to solve my problem (and I think it work so good). 1. I created a DataGridView and I chose as Data Source, the Binding Source of the first table. 2. I added unbound columns to the DataGridView according to the second table. 3. I added a handler for DataBindingComplete event of the DataGridView. 4. I added the following code in that handler in order to fill the cells corresponding to the second table: foreach (DataGridViewRow listRow in listDataGridView.Rows) { int addressId = (int)listRow.Cells[2].Value; CompaniesDataSet.AddressesRow addressRow = companiesDataSet.Addresses.FindByAddressId(addressId); listRow.Cells[4].Value = addressRow.Address; listRow.Cells[5].Value = addressRow.City; listRow.Cells[6].Value = addressRow.ZIPCode; listRow.Cells[7].Value = addressRow.State; } (I hope you can understand my explanation because my English is not so good.) Thank you very much, again.

-- Adrián Córdoba