I am using the "BeforeRowFilterChanged" event to capture the filter condition entered by the user. I then pepare my own db query and execute it as my db table my have a million records. The problem I am having is I am batching x number of records at a time and the offend event of the bindingsource will continue to fire until all the records are retrieved. I am assuming this is because the grid needs to grab all records in order to properly apply the filter. Since I am handling the filter can I tell the grid this besides using e.Cancel to cancel the filter event? If I use e.Cancel then my column filter icon does not show that a filter is current on the column.
It sounds like you want to do external filtering - in other words, have the grid display the FilterUI, but not actually filter the data so that you can filter it yourself.
What version of the grid are you using? We added this feature only recently, so it may not be available if you are using an older version.
Enabling External Filtering
In what version was the External Row Filtering added?
Hello Roger,
This is a feature which has been added in 12.1 version of NetAdvantage for Windows Forms.
Please do not hesitate to contact me if you need any additional assistance.
Thank You.