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");
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");
private void dataGrid1_CurrentCellChanged(object sender, System.EventArgs e)
{
if(dataGrid1.VisibleRowCount == 0)return;
DataSet ds2=New DataSet();
//根据ds1.Tables[0].Rows[dataGrid1.CurrentRowIndex]["主键"]得到ds2
dataGrid2.DataSource=ds2.Tables[0];
}