Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-19 : 09:27:55
|
| Vivek Agarwal writes "Hi ,I have one web page that should display 50 records per page. From SQL server it returns 1000 of records and that it is splited inot pages and displayed on screen. Because of this ASP pages are not working fast. Toslove this, we want to fetch the data related to a particular page only. I mean first 50 rec should be fetched and displayed. On going 2nd page, next 50 records should be fetched and displayed. Please give me solution of that..." |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2002-12-19 : 09:53:03
|
| If I had to do this now, I'd sure want to use the .NET datagrid object.But if you're stuck (as I am) with ASP there are several ways to do this. One technique that looks very promising (I haven't tried it myself) is described elsewhere at[url]http://www.aspfaqs.com/webtech/062899-1.shtml[/url]I thought sqlteam had an article on this technique, but I was unable to locate it.Anyone else?Sam |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-19 : 10:00:51
|
| http://www.sqlteam.com/SearchResults.asp?SearchTerms=paging |
|
|
|
|
|
|
Pagination in SQL server and ASP