Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server , +
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 16-Jul-11 0:16am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,
 

Check this[^]
 

And this[^]
  Permalink  
Comments
ram_kumar at 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 at 16-Jul-11 7:45am
   
http://www.codeproject.com/KB/aspnet/DataListPaging.aspx
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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 !.
  Permalink  
Comments
ram_kumar at 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 at 16-Jul-11 7:11am
   
watch this video.it helps a lot.
 
http://www.youtube.com/watch?v=z0Txt4UESg4
ram_kumar at 16-Jul-11 7:29am
   
thanks sir for help me i am try by this mathod
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

  Permalink  
Comments
ram_kumar at 16-Jul-11 10:10am
   
sorry sir but i am very upset becuase myboss is very rud. he said do immedatly
thatraja at 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 at 16-Jul-11 11:44am
   
never let your boss control your personality.Just explain to him that this need time !
thatraja at 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 content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 543
1 OriginalGriff 384
2 George Jonsson 258
3 Abdul Samad KP 135
4 Animesh Datta 130
0 OriginalGriff 6,099
1 Sergey Alexandrovich Kryukov 5,411
2 CPallini 4,770
3 George Jonsson 3,400
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 16 Jul 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100