Advanced DataSet filtering question

[Mervin Williams]

I have a dataset that includes data adapters for two tables, Company and
User, and one for the intersection table, Company_User. I've set up
DataRelations between the tables within the dataset .xsd file.

How do I now apply a filter that restricts the Company to only display those
records accessible by a specific, as indicated in the Company_User table?

Can the DataRelation not be used to restrict the rows received in both the
parent and child tables?

All help will be greatly appreciated.

Mervin Williams

 

[Alvin Bruney [MVP]]

one approach is to simply set the filter on a per table basis. So for
example, if you need to show only rows for company xyz, then you apply a
filter on the datatable to filter companies not belonging to xyz. This
disadvantage of this technique is that you would need to manually add the
filtering and be responsible for keeping it up to date assuming it changes,
the good thing is that it is quick and painless if time is a factor