master detail relationship without typed dataset
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.