Filter Hierarchical GridDataBoundGrid

[Administrator]

Is it possible to filter 2-level GDBG after data has been loaded?

I use dataset with two tables as DataSource.

Then I would like to filter data on both levels when user checks/unchecks checkbox "Hide not active" or "Hide not completed", etc.

I tried DefaultView.RowFilter and DataViewManager but with no success.

[Administrator]

My code:

dataset.Tables["Table0"].DefaultView.RowFilter = filterCreteria1;
dataset.Tables["Table1"].DefaultView.RowFilter = filterCreteria2;
grid.DataSource = dataset;

How can I make grid to be filtered?

[Administrator]

Hi Olga, The DataViewManager can be used to filter the child table and after setting the RowFilter reset the DataBinding of the grid. And the currencyManager.List can be used as the DataView to filter the root level table. Here is a sample. Regards, Calvin.

40578.zip

[Administrator]

Calvin,

Thank you for the sample.
I''ve already resolved this problem by similar way:

dvm = new DataViewManager(dataSet);
dvm.DataViewSettings[tableName1].RowFilter = filterString1;
dvm.DataViewSettings[tableName2].RowFilter = filterString2;
grid.DataSource = dvm;

It also works!