Running out of ideas
-
I need to filter rows on the view of the parent table of a relationship shown on a datagrid based on a RowFilter set on the view of the child table. I tried deleting all the rows in the parent table and the reset the row state back for each row that is a parent of rows in the child table that are not hnidden but deleting parent rows apparently deletes rows in the child table also. Not sure if there is another way to do this.
-
I need to filter rows on the view of the parent table of a relationship shown on a datagrid based on a RowFilter set on the view of the child table. I tried deleting all the rows in the parent table and the reset the row state back for each row that is a parent of rows in the child table that are not hnidden but deleting parent rows apparently deletes rows in the child table also. Not sure if there is another way to do this.
Have you tried reading all data into a dataset? You can then create a constraint between your two tables (or more) and find parent and child rows using a certain datarelation between those tables.
- - - --[ i love it when a plan comes together ]-- - - -