I'm working with very large databases and filtering (and sorting) at the database server. I'm using the RadGridView filtering and sorting but catching the events and triggering a requery at the database server after gathering the users filter and sort choices and converting them to SQL.
So far so good however I ran into a problem:
When a new filter is created I catch that in the grid's Filtered event and examine for distinct filters and field value filters and build accordingly. The problem comes when a user *removes* the filter from a column as there is no event fired that I can see so there's no way I know of to trigger another query.
Ideally I wish the GridView just had an event that indicated it needed a refresh of it's data when a user filters or sorts or changes column order etc to support people like me who are not going to simply send a gigabyte of data directly to the grid to allow it to do the sorting and filtering itself. That way I could just iterate the columns build my sort and filter all at once in one go and be done with it.
This doesn't appear to be supported however or I missed something (which seems likely, because who builds a grid with no support for filtering and sorting at the back end?) so if my approach is wrong I'd love to hear about it. If not then how do I determine when the user has *removed* a filter from a column?
So far so good however I ran into a problem:
When a new filter is created I catch that in the grid's Filtered event and examine for distinct filters and field value filters and build accordingly. The problem comes when a user *removes* the filter from a column as there is no event fired that I can see so there's no way I know of to trigger another query.
Ideally I wish the GridView just had an event that indicated it needed a refresh of it's data when a user filters or sorts or changes column order etc to support people like me who are not going to simply send a gigabyte of data directly to the grid to allow it to do the sorting and filtering itself. That way I could just iterate the columns build my sort and filter all at once in one go and be done with it.
This doesn't appear to be supported however or I missed something (which seems likely, because who builds a grid with no support for filtering and sorting at the back end?) so if my approach is wrong I'd love to hear about it. If not then how do I determine when the user has *removed* a filter from a column?