How to get the total page of LINQ pagination

Question

Based on this answer on how to apply paging on a list.

I would like to extend this question of how can we get the total page of a list with a specific total collection of item per page?

For example, suppose i have 50 items each page has 12 items. How can i get the total page?

With "total page", do you mean the number of the last page? e.g. "displaying page 1 of 14" and you want to get the "14"? — Georg Patscheider, Aug 30 '16 at 06:58
@GeorgPatscheider yes sir that is what i mean sorry for bad english — Shift 'n Tab, Aug 30 '16 at 09:51

score 3 · Accepted Answer · answered Aug 30 '16 at 06:59

3

Isn't it simple math?

Page count = Round(Total Records / Page Size)

in C#

int totalItemCount = myList.Count();
int pageSize = 10;

int pageCount = System.Convert.ToInt32(System.Math.Ceiling(totalItemCount / System.Convert.ToDouble(pageSize)));

answered Aug 30 '16 at 06:59

ViRuSTriNiTy

5,017
2
32
58

score 1 · Answer 2 · answered Aug 30 '16 at 07:01

1

You will need to know upfront how many records you have in total.

To do this simply use yourquery.Count(). It will translate to sql to some query beginning with SELECT COUNT(*)... and will not iterate over every single record.

answered Aug 30 '16 at 07:01

Mauro Sampietro

2,739
1
24
50

How to get the total page of LINQ pagination

2 Answers2