Click here to Skip to main content
15,886,030 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi I am New in asp.net Plz Help me Its urgent.
How to do "google like" paging in Asp.Net? You only show links to 10 first search result pages, then when I click page 10, additional 10 more pages are added to search results etc.

I have a typical search form and list of search results. There are possibly many search result pages.

Typically only the first few search result pages are interesting and but it must be possible to also see all search results.

I'd like to do something like this:

1. Initially first 10 search result pages are queried
2. If user clicks page 10, additional 10 search result pages are queried.
3. If user clicks page 20, additional 10 search result pages are again queried.

I do not want to fetch all search results in one go, and I do not want to fetch number of all search results. I just want to fetch next 10 search result pages.

I am Doing paging with dataset but it not Provide the efficient paging so i am want to paging with sql stored procedure.
Posted

 
Share this answer
 
Comments
Ram Kumar(Webunitech) 16-Jul-11 10:10am    
sorry sir but i am very upset becuase myboss is very rud. he said do immedatly
thatraja 16-Jul-11 10:20am    
But reposts never help you to get quick answers only you will get downvotes.

BTW Did he give you enough time for your work? Are you happy with your work?
mhamad zarif 16-Jul-11 11:44am    
never let your boss control your personality.Just explain to him that this need time !
thatraja 16-Jul-11 11:48am    
Agree dude, But I asked him because he was a Network Engineer(from his CP profile) & recently moved to .NET. So I want his feedback about his job. I didn't blame his boss.
This link provides exactly what you want.It is paging a datalist like google in a friendly seo way.

http://weblogs.asp.net/stanly/archive/2011/05/03/custom-seo-friendly-paging-in-datalist-like-google.aspx[^]

Good luck !.
 
Share this answer
 
Comments
Ram Kumar(Webunitech) 16-Jul-11 7:01am    
Dear sir i am already read this articles but some mistake in articles. if you have any demo plz send me. it very urgent sir. plz help me
thanks
ram kumar
kumar88.ram@gmail.com
mhamad zarif 16-Jul-11 7:11am    
watch this video.it helps a lot.

http://www.youtube.com/watch?v=z0Txt4UESg4
Ram Kumar(Webunitech) 16-Jul-11 7:29am    
thanks sir for help me i am try by this mathod
Initially first 10 search result pages are queried
You have to pull only 10 records from the database by passing the the start and ending row number.

SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table[^]

http://www.beansoftware.com/ASP.NET-Tutorials/SQL-Queries-Paging.aspx[^]
 
Share this answer
 
 
Share this answer
 
Comments
Ram Kumar(Webunitech) 16-Jul-11 6:38am    
Dear sir,
I check this solution which is provided by you. plz provide the link with datalist and i am apply your solution. if u any articles on datalist custom paging with sql server plz provide me.
thanks
Ram Kumar
Syed Salman Raza Zaidi 16-Jul-11 7:45am    
http://www.codeproject.com/KB/aspnet/DataListPaging.aspx

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900