How to find which page does a record available in Grid

[ArunDhaJ]

Hi All,
I've a grid with say 100 records with pagination of 10 records per
page. Given a record, how can I identify which page does this record
is available?
As the grid size can be much larger than 20K records, looping each
records would be a bad approach. Is there any other way so that I can
find the page number?


Thanks in Advance.
ArunDhaJ

 

[Peter Morris]

int pageNumber = topMostIndex / itemsPerPage;

 

[ArunDhaJ]

I wont be having topMostIndex value.

I think u didnt get my query.

Say a grid contains following columns
Name, Age, Department

consider the following record is 12th record
Arun, 22, ComputerScience

through C# code I've to calculate which page does this record with
name "Arun" comes. i.e. Page 2.

I hope I've explained. If you need further clarifications please post
back.

Thanks
ArunDhaJ

 

[Jim H]

I wont be having topMostIndex value.

I think u didnt get my query.

Say a grid contains following columns
Name, Age, Department

consider the following record is 12th record
Arun, 22, ComputerScience

through C# code I've to calculate which page does this record with
name "Arun" comes. i.e. Page 2.

I hope I've explained. If you need further clarifications please post
back.

Thanks
ArunDhaJ

int PageNum = (RecordNumber / RecordsPerPage) + 1;

Given your scenario: PageNum = (12 / 10) + 1
Record appears on Page 2