Paging data from sql database

[socrates anibal rivera rivera]

Hello.

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

[Vijayarasan Sivanandham]

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.

Regards,

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