I am guessing that the virtualization sets up all the hidden internal activity (cell query events etc) necessary for the grid to access the fully populated OrdersListDetails (which is a List of count OrderInfo instances.)
In sfDataGrid there does not seem to be a path for doing page based virtualization using queries against a remote data service.
Q: Is there a accessible event in sfDataGrid like GridControl's QueryCellInfo event ?
Q: Do I have to forgo the sfDataGrid and fall back to using GridControl where I would have to code the event handlers QueryRowCount, QueryColCount, QueryCellInfo,to make the Grid operate ?
I think that within the QueryCellInfo handler I would be able to know if another 'page' of data has to be queried from the remote database and cached for use in future callbacks to QueryCellInfo
SSSusmitha Sundar Syncfusion Team August 28, 2019 11:57 AM
Query 1: In sfDataGrid there does not seem to be a path for doing page based virtualization using queries against a remote data service
We have paging support for SfDatagrid. You can load the data by OnDemandLoading. But you did not load the DataTable directly to paging datasource. You need to change the datatable to dynamic object and set this to datasource of Pager. It will loading data by page manner.