Search This Blog

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();

1 comment:

  1. How do I want to show page in View?
    Ex:
    << < 1 2 3 ... 5 6 > >>

    If @model IpageList then it auto fill page above for me.
    But I use total, skip, pagesize it do not work.

    ReplyDelete