Q:

What is the best procedure to implement paging in a gridview considering size of Record?

I have a table in sq server db having more than 1 million rows. 
I need to show those data in a gridview with pagination in an asp.net page.
Since the record amount is larger I need to boost performance of the page for showing data, implementing pagination.
What procedure should I follow to implement pagination?
Please help.

A:

There are a number of ways to do it but the general concept is "fetch on demand". You do not need to fetch record 200 to 250 when displaying the first 50 in the first page.
There are some very intelligent implementations which mix Ajax in to improve user experience and also look-ahead and/or background fetching, e.g. fetch 100 for page-size of 50 so viewing next page is faster.
You might want to start from more straightforward ones, Google around you should be able to find.
A couple here:
Effective Paging with Large Amount of Data in ASP.NET
Effective Data Paging Using SQL Server 2005 and Microsoft's Enterprise Library 

