search result for paging

I am using Stored Procedure for a Search program.

Search result may be more than 10 records.

If I were to show the result of more than 10 records on page 1, 2 and 3 each.

Now if user click on 2 be like that again, do not complete the search

how can paging result without ful开发者_JAVA百科l search in any page 1,2,3?

if use session["search"]=datasource in first search and use future .now how can we access to session["search"] row 0,1,2;?

It's hard to understand exactly what you're asking. Here is a good thread on sql server paging though.

SQL Server 2008 paging methods?

Your question not very clear. Can't understand what you need. However if you are referring to paging in asp.net and c#, then the following tutorials may be of help:

Efficiently Paging Through Large Amounts of Data

Paging In ASP.NET