how to apply filter to Master/Detail records in dataset
-
Dear All! I have fill the ADO.NET dataset with two tables and joined them as a master/detail. I want to filter this dataset by applying filter on master table records. Does anybody know, how to apply filter on dataset have two tables as master/detail. Email: imran_shahid@msn.com
-
Dear All! I have fill the ADO.NET dataset with two tables and joined them as a master/detail. I want to filter this dataset by applying filter on master table records. Does anybody know, how to apply filter on dataset have two tables as master/detail. Email: imran_shahid@msn.com
If you are using more than one table in a dataset you should already have defined the relationships between them. If you did not, look to the msdn for Relations in DataSets. After you filter the master table you can get the the other table's related rows by using the GetChildRows method of each row on the master table. I hope it helps.