The datasource we are using has around 50K records. We want to implement virtual paging so at time only 50 records are bound to the grid.
We would need to control search and sort functionality of the grid to make sure the virtual page contains the 50 records according to the set criteria. Is there a way to override the default search and sort functionality of the grid and pass the control to the datasource. The datasource implements IBindingList, I thought the grid would use the ApplySort. Find and other function of IBindingList by default.
Hi,
There's no search functionality in the grid. So the only issue here is sorting. What you could do is set the HeaderClickAction to one of the "External" modes. This would show the SortIndicators in the column headers just as though the grid was sorting the data, but no actual sorting would be done by the grid. You would then handle the grid events like Before/AfterSortChange and handle the sorting yourself on the data source and then refresh the grid's display.
Thanks for the info about sort.
By Search I meant Filtering. User can filter rows on the grid. However with limited data being bound to the grid the default filter would not give the true representation. So I guess it would require something similar to sort for handling back to the datasource.
I am curious, since the IBindingList has the interface for sorting and filtering why doesn't infragistics use that API specially in the External modes.
The grid doesn't have anything similar for Filtering, since IBindingList does not actually support filtering. I suppose it would make sense to add something for cases like yours, though. So I encourage you to Submit a feature request to Infragistics.
bhavesh_busa said:I am curious, since the IBindingList has the interface for sorting and filtering why doesn't infragistics use that API specially in the External modes.
Well, just to be clear, IBindingList does not have an interface for Filtering. Searching and filtering are not the same thing.
Anyway, I suspect the reason is that the grid deals with the BindingManager in DotNet and the BindingManager does not expose any filtering or sorting. The grid can also bind to an IList, which does not have sorting, filtering, or searching capability.