-1

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 full 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;?

Mangesh
  • 3,987
  • 2
  • 31
  • 52
mytestleft
  • 1
  • 2
  • 1
    You will have to maintain the DataSource somewhere like in the session and bind it again in the page index changed event, this will not cause you to hit the database again. Hope this is what you are looking for – V4Vendetta Jul 18 '11 at 06:34
  • Except for the session can be used from another data source – mytestleft Jul 18 '11 at 06:39
  • Now Session["search"]=datasource; now how can access to row 0,1,... – mytestleft Jul 18 '11 at 06:48
  • 2
    It's very difficult to know the intention of the question Please check the grammer before posting the question. – Mangesh Jul 18 '11 at 06:56

2 Answers2

0

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?

Community
  • 1
  • 1
Tory Netherton
  • 753
  • 5
  • 23
0

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

Jayesh
  • 1,511
  • 1
  • 16
  • 37