Site icon Dotnet Helpers

The data source does not support server-side data paging.

Error :  The data source does not support server-side data paging.

Description:  Error message occure while binding the result set to the Gridview using LINQ Query as like below

gvDetails.DataSource = details

Reason : We cant use an IQueryable object to data bind to a GridView and still use Paging and Sorting.

we must return a List to the GridView using the ToList() method.
Solution:  In that scenario we want to add .ToList() as like below

                         gvDetails.DataSource = details.ToList();

Exit mobile version