Hi,
I am having an issue using the Syncfusion.GridHelperClasses.GridExcelFilter with the Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl.
I am using the GridExcelFilter to filter records, but I do not understand which event handler I should subscribe to, in order to detect that the user has filtered the grid.
In the attached example program (GroupingGridWithExcelFilters.zip), the following is done:
- The grid is initially populated with 20 records
- The filter is used to choose to display only 3 records
- There is a handler for the event GridExcelFilter.RecordFiltersItemChanged. When this handler is invoked, I use a debug breakpoint and I see that the GridGroupingControl.Table.FilteredRecords property still has 20 records...the records have NOT been filtered at this point!!
- I allow execution to continue, and the user interface has filtered the records so that only 3 records are shown
- If I push the button "Press This Button After Filtering", the button Click event handler is invoked. I used a debug breakpoint to see that the GridGroupingControl.Table.FilteredRecords property now has 3 records
So, it appears that the filtering is happening correctly...but I do not have an event (to handle) that is fired at an appropriate time. Obviously, I cannot expect the users to push a button after each time they filter records. This needs to happen automatically, when the filter is applied.
From looking in the support forums, it seems that this same issue was previously reported in June 2013, here:
http://www.syncfusion.com/forums/109631/event-after-filter-e-g-via-gridexcelfilter-is-applied
However, this forum thread does not contain any indication of if/how this issue was resolved.
Can anybody suggest how I should register for an event to detect that the filters have changed?
Regards,
Stephen New
Attachment:
GroupingGridWithExcelFilters_3d1cf325.zip