Paging ListView With DataPager and skip, take

Question

i use this code for paging Listview control in asp.net.

Paging ListView With DataPager

but i want use skip and take for paging Listview.

I did a lot of searching but could not find the correct answer

Answer 1

To do true custom paging where you only get the exact records that will be displayed on the current page, then you will need to use some form of LINQ provider (LINQ to SQL, LINQ to Entities, etc.), because the .Skip() and .Take() methods will not be able to provide that custom paging context without being able to influence the query for retrieving the data from the database.

In other words, the paging power of .Skip() and .Take() on the entire list of the total records of all the pages is significantly weakened when applied as LINQ to Objects, because it will not be able to provide just a single page of data.

In short, you need to decide which LINQ to XYZ flavor of database functionality you want to use that allows for .Skip() and .Take() to truly exercise efficient, custom paging on your behalf.

If you decide to use LINQ to SQL, then you should check out the LinqDataSource class, specifically the AutoPage property, because that is a built-in use of the .Skip() and .Take() functionality you are looking for.