Paging in dynamically populated data

[Sajin]

Hi,

I have a sfdatagrid in which data is dynamically loaded from database.

I want to implement paging functionality in the sfdatagrid.

please provide the necessary steps to accomplish this.

Also please help with data virtualisation in sfdatagrid as i cannot find in detail example in documentation.

Thanks & regards,

Sajin

[Mohanram Anbukkarasu]

Hi Sajin, 

Thanks for contacting Syncfusion support.  

If you are retrieving data from the database as DataTable, it is not possible to implement paging, as SfDataPager doesn’t accept DataTable as source. You can use IEnumerable colletion as source for SfDataPager. Please refer the below given help documentation to know more about paging in SfDataGrid and its limitations. 

UG references :  

https://help.syncfusion.com/windowsforms/datagrid/paging 

https://help.syncfusion.com/windowsforms/datagrid/paging#limitations 

Virtualization support in SfDataGrid helps to handle large amount of data with better performance. It can be enabled by using SfDataGrid.EnableDataVirtualization property. Please revert to us with details if you require further more assistance from us.  

Regards, 

Mohanram A. 

[Sajin]

Yes i am using DataTable and at this moment switching to innumerable is not feasible.

Thats aside,can i just use enablevirtulization property alone on sfdatagrid with datatable to increase performance also how will i know or how can i verify the difference in performance after enabling enablevirtuluzation property.

Thanks in advance.

[Mohanram Anbukkarasu]

Hi Sajin, 

Thanks for the update.  

We regret to inform that DataTable is not supported for DataVirtualization in SfDataGrid. Please let us know if you require any other assistance from us.  

Regards, 

Mohanram A.