search result for paging

Question

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

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
Now Session["search"]=datasource; now how can access to row 0,1,... — mytestleft, Jul 18 '11 at 06:48
It's very difficult to know the intention of the question Please check the grammer before posting the question. — Mangesh Pimpalkar, Jul 18 '11 at 06:56

score 0 · Answer 1 · edited May 23 '17 at 12:11

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?

edited May 23 '17 at 12:11

Community

1
1

answered Jul 18 '11 at 06:43

Tory Netherton

733
5
22

score 0 · Answer 2 · answered Jul 18 '11 at 06:51

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

answered Jul 18 '11 at 06:51

Jayesh

1,439
1
16
34

search result for paging

2 Answers2