Search This Blog

Showing posts with label then next 10. Show all posts
Showing posts with label then next 10. Show all posts

Thursday, July 21, 2016

Selecting first 10 records, then next 10, paging using Linq

var total = dtDetails.Rows.Count;
var pageSize = 10; // set your page size, which is number of records per page

var page = 1; // set current page number, must be >= 1

var skip = pageSize * (page-1);

var canPage = skip < total;

if (canPage) // do what you wish if you can page no further
   return;

DataTable dtFilteredData= dtDetails.AsEnumerable().Skip(skip).Take(pageSize).CopyToDataTable();