How to create server-side pagination and data binding in Blazor Server App?

[Fardin]

I want to use Syncfusion.Grid in my project (Blazor Server App). I'm loading a heavy data (more than 200000 records) from SQL Server (installed locally on the same server the Blazor App in running). Please provide an example for data binding and server side pagination (along with filtering and sorting) for Syncfusion.Grid in a Blazor Server App.

Thanks.

[Sarveswaran Palani]

Hi Fardin,

Greetings from Syncfusion support.

From your query, we suspect that you want to consume data from SQL Server and bound it to Blazor DataGrid. You can achieve this requirement by using Custom Adaptor. We’re already discussed about this topic in our UG documentation. Kindly refer the attached links documentation and examples.

Reference: https://blazor.syncfusion.com/documentation/datagrid/data-binding#sql-server-data-bindingsql-client
              https://blazor.syncfusion.com/documentation/datagrid/custom-binding

             https://github.com/SyncfusionExamples/blazor-grid-sqldatabinding

Regards,
Sarvesh