How to: Create Master/Detail Lists with the Windows Forms DataGrid Control
Thecontrol replaces and adds functionality to the control; however, the DataGrid control is retained for both backward compatibility and future use, if you choose. For more information, see .
If yourcontains a series of related tables, you can use two DataGrid controls to display the data in a master/detail format. One DataGrid is designated to be the master grid, and the second is designated to be the details grid. When you select an entry in the master list, all of the related child entries are shown in the details list. For example, if your DataSet contains a Customers table and a related Orders table, you would specify the Customers table to be the master grid and the Orders table to be the details grid. When a customer is selected from the master grid, all of the orders associated with that customer in the Orders table would be displayed in the details grid.
To set a master/detail relationship programmatically
Create two new DataGrid controls and set their properties.
Add tables to the dataset.
Declare a variable of typeto represent the relation you want to create.
Instantiate the relationship by specifying a name for the relationship and specifying the table, column, and item that will tie the two tables.
Add the relationship to the DataSet object'scollection.
Use themethod of the DataGrid to bind each of the grids to the DataSet.
The following example shows how to set a master/detail relationship between the Customers and Orders tables in a previously generated DataSet (ds).
Dim myDataRelation As DataRelation myDataRelation = New DataRelation _ ("CustOrd", ds.Tables("Customers").Columns("CustomerID"), _ ds.Tables("Orders").Columns("CustomerID")) ' Add the relation to the DataSet. ds.Relations.Add(myDataRelation) GridOrders.SetDataBinding(ds, "Customers") GridDetails.SetDataBinding(ds, "Customers.CustOrd")
DataRelation myDataRelation; myDataRelation = new DataRelation("CustOrd", ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]); // Add the relation to the DataSet. ds.Relations.Add(myDataRelation); GridOrders.SetDataBinding(ds,"Customers"); GridDetails.SetDataBinding(ds,"Customers.CustOrd");
DataRelation^ myDataRelation; myDataRelation = gcnew DataRelation("CustOrd", ds->Tables["Customers"]->Columns["CustomerID"], ds->Tables["Orders"]->Columns["CustomerID"]); // Add the relation to the DataSet. ds->Relations->Add(myDataRelation); GridOrders->SetDataBinding(ds, "Customers"); GridDetails->SetDataBinding(ds, "Customers.CustOrd");