Thank you for writing.
1. It doesn't matter whether you use a DataTable
or a List<T>
only uses the CellValueNeeded
event to populate the required cell value. It is up to you how exactly you extract the records. I would recommend you to have a look at our Demo application >> VirtualGrid >> Filtering with DataFilter
example which demonstrates how to fetch the relevant data considering the filter criteria. If no records match the filter criteria, RadVirtualGrid
is displayed empty. The Demo application is located in the installation folder of the suite which is usually located at the following path: C:\Program Files (x86)\Progress\Telerik UI for WinForms R3 2017\Examples\QuickStart\Bin
2. The filtering behavior in RadVirtualGrid
is fully controlled by the developer. Hence, it can be always considered as custom. You select what data exactly to be shown in the grid. The following help article demonstrates a sample approach how to filter the grid: https://docs.telerik.com/devtools/winforms/virtualgrid/filtering/filtering
requires only to specify the rows/columns count. Then, the CellValueNeeded
event is fired each time a new cell value is needed when you scroll for example. It is up to you how exactly you will filter and extract the necessary data from your DataSource
gives you the opportunity to fully manage a large amount of data. You can refer to general programming forums like StackOverflow
where different ideas for filtering millions of records in the DataSource
collection are discussed. Thus, you can choose which approach suits your requirement best.
I hope this information helps. Should you have further questions I would be glad to help.