Filtering a GridDataBoundGrid

[Brian Schlatter]

Is it at all possible to filter a GridDataBoundGrid object if its DataSource is anything but a DataTable/DataSet? I, for example, have an ArrayList (as the DataSource) and I do not wish to use a GridFilterBar.

Thanks,
Brian

[Administrator]

Hi Brain,

There is no built-in support for ArrayList filtering in a GridDataBound. The RowFilter support in a GridDataBoundGrid is based on the DataView.RowFilter property . You could implement you own support for filtering using QuerycellInfo event. The idea would be when you filter, to go through the full datasource, and remember the status of the visible rows (maybe in an HashTable). Then in your virtual implementation, you need to show/hide the proper rows. You can see this type of implementation in the attached sample.

Here is a sample.
http://www.syncfusion.com/Support/user/uploads/ArrayListGrid_7ecaa054.zip

Let us know if this helps.
Best Regards,
Haneef

[Brian Schlatter]

This is a good solution but I ran into performance problems working with grid of 1,000+ items. Got a lot of ideas from it though. Thanks again.