We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Paging data from sql database


On this setting, I am lost on how to best proceed since pager does not accept datatable.

A (perhaps NorthWind) database example would be very welcome.

Thanks in advance.

Best regards,

Sócrates Aníbal Rivera Rivera

1 Reply

VS Vijayarasan Sivanandham Syncfusion Team November 18, 2022 01:10 PM

Hi Socrates anibal rivera rivera,

SfDataPager doesn’t accept DataTable as a Source. We have mentioned in our user documentation as a limitation of SfDataPager. Refer to the below link for your reference,

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

However, we have prepared the sample to meet your requirement. Please find the sample in the attachment.


Vijayarasan S

If this post is helpful, please consider Accepting it as the solution so that other members can locate it more quickly.

Attachment: Sample_3d6d1d03.zip

Live Chat Icon For mobile
Up arrow icon