Hello, I have a dataset1which contains 2 datatables, and add a datarelation between these 2 datatables, table1 and table2. The parentcol and childcol of this dataset1 are linked with column 'Num'. I've got a DataGrid control in form1 with data source is the parent table(table1) and another DataGrid control in form2 which its data source is also the parent table but data member is the child table(table2 in dataset1). How can I retrieve the related data of the child table display in DataGrid within the Form2 after a selection is made from DataGrid Form1?
E.g. Database : Sql server 2000
ParentTable's columns : Num, Name, Address
ChildTable's columns: Num, Order, Date
DataGrid in Form1 : parentTable as data source
DataGrid in Form2: ChildTable as data member
When a selection is made( e.g Num = 3), then should be retrieve all related data or row for Num = 3 only from ChildTable to display into DataGrid Form2 when a button is clicked.
Suppose i using BindingContext to make it?