refreshing data after applying filter

[Administrator]

Hi,

I would like to apply a filter to a gridhierdatabound grid and all of its child grids based on a menu selection. Is there any example somewhere on how to do this? I don''t want to lose any of the changes the user may have made to the grid before applying the filter

Thanks again!

[Administrator]

You set the parentDataTable.DefaultView.RowFilter property to the row filter you want to apply..

[Administrator]

THanks, that worked great. I noticed that when I try to apply the filter when I am still on a record that was just edited, I sometimes get an error '' no row at position one''. Is there some way to commit changes to all records before applying the filter?

>You set the parentDataTable.DefaultView.RowFilter property to the row filter you want to apply..

[Administrator]

Try calling grid.CurrentCell.EndEdit() and grid.Binder.EndEdit() before setting the filter.

[Administrator]

THanks

>Try calling grid.CurrentCell.EndEdit() and grid.Binder.EndEdit() before setting the filter.