Infralution Support

[mutouaa]

Hi Infralution Group,

I have a small problem in applying filter when use a DataSet as tree datasource.
let's see the example, I have a DataSet with two tables A and B, Relation relation_A_B(A as parent of B). In the tree I have two Levels, Level 1 displays Table A, level 2 displays Table B.
here I would like to apply a filter in a column Active of B. after I set B.DefautlView.RowFilter = "Active = 'True'", it doesn't work. but in Table A it works.
Could you please give some suggestion on this topic?

BTW, for now I use method ReloadChildren to filter Table B, but this has some disadvantage when Table B changes.

thank you in advance.

[Infralution]

The DataRowRowBinding class finds the children for a given parent row by calling DataRowView.CreateChildView(relation). This creates a separate DataView based on the parent/child relation. Setting the RowFilter on the DefaultView will not affect these child DataViews. To implement filtering on child rows you need to set the filter on these DataViews when they are created. To do this you can handle the GetChildren event and use the default RowBinding method to get the children. Then extract the underlying DataView and set the RowFilter (see below). Note that the DataRowRowBinding adds a DataViewList wrapper around the underlying child DataView. The code below sets a filter on Orders table of the DataSet Browser sample project.