master detail relationship without typed dataset

Nov 16 2004 5:00 PM
Hi, I would like to know if it's possible to create a master detail relationship specifying as diplay member of datagrid2 the master detail relationship,without using a typed dataset. SqlDataAdapter da=new SqlDataAdapter(cmd1); da.Fill(ds3,"Customers"); da.SelectCommand=cmd2; da.Fill(ds3,"Orders"); DataColumn parentCol=ds3.Tables["Customers"].Columns["CustomerID"]; DataColumn childCol=ds3.Tables["Orders"].Columns["CustomerID"]; DataRelation relation=new DataRelation("Customers_Orders",parentCol,childCol); ds3.Relations.Add(relation); dataGrid1.DataSource=ds3.Tables["Customers"]; dataGrid2.DataSource=ds3; dataGrid2.DataMember="Customers.Customers_Orders"; I tried it and it doesn't work.