14

I'm looking for a decent paging control in ASP.NET, much like the Stackoverflow pager. Can anyone recommend one?

I'd prefer one that didn't use Postback either, just a customisable querystring.

Chris S
  • 64,770
  • 52
  • 221
  • 239

6 Answers6

11

It's quite easy to roll your own. I created a simple user control based on the stack overflow pager with two properties...

  1. Total number of pages available according to the underlying data
  2. Number of links to show

The selected page is determined by reading the query string. The biggest challenge was altering the URL with the new page number. This method uses a query string parameter 'p' to specify which page to display...

string getLink(int toPage)
{
    NameValueCollection query = HttpUtility.ParseQueryString(Request.Url.Query);
    query["p"] = toPage.ToString();

    string url = Request.Path;

    for(int i = 0; i < query.Count; i++)
    {
        url += string.Format("{0}{1}={2}", 
            i == 0 ? "?" : "&", 
            query.Keys[i], 
            string.Join(",", query.GetValues(i)));
    }

    return url;
}

A simple formula to determine the range of page numbers to show...

int min = Math.Min(Math.Max(0, Selected - (PageLinksToShow / 2)), Math.Max(0, PageCount - PageLinksToShow + 1));
int max = Math.Min(PageCount, min + PageLinksToShow);

Each link then gets generated using something like (where min and max specify the range of page links to create)...

for (int i = min; i <= max; i++)
{
    HyperLink btn = new HyperLink();
    btn.Text = (i + 1).ToString();
    btn.NavigateUrl = getLink(i);
    btn.CssClass = "pageNumbers" + (Selected == i ? " current" : string.Empty);
    this.Controls.Add(btn);
}

One can also create 'Previous' (and 'Next') buttons...

HyperLink previous = new HyperLink();
previous.Text = "Previous";
previous.NavigateUrl = getLink(Selected - 1);

The first and last buttons are straight forward...

HyperLink previous = new HyperLink();
previous.Text = "1";
first.NavigateUrl = getLink(0);

In determining when to show the "...", show a literal control when the link range is not next to the first or last pages...

if (min > 0)
{
    Literal spacer = new Literal();
    spacer.Text = "&hellip;";
    this.Controls.Add(spacer);
}

Do the same for above for "max < PageCount".

All of this code is put in an override method of CreateChildControls.

Tom
  • 845
  • 7
  • 12
  • I've noticed it also does [Prev] 1..2 3 4 5...213 [Next] – Chris S Mar 17 '09 at 09:06
  • Note: This example produces page links that are 0 based, i.e. p=0 for the first page. The example can be changed if the first page link needs to be 1. Hope that makes sense and this helps! – Tom Mar 17 '09 at 10:17
4

I was expecting more answers but it looks like a lot of people just make their own. I've found a decent one that is maintained quite often on codeproject.com

cp

It's not quite the same as the stackoverflow.com one. It'd be nice if there was a decent open source control that had a variety of different output options.

Community
  • 1
  • 1
Chris S
  • 64,770
  • 52
  • 221
  • 239
2

I've worked with the DevExpress and Telerik page controls and prefer the DevExpress pager. I'm not sure if the DevExpress pager can work directly with a querystring but I would be surprised if it didn't as it is very flexible. As far as paging between existing pages after download, everything can reside on the client or, if a trip to the server is necessary, the control is fully AJAX equipped. I suggest you start your search at www.devexpress.com and then check out www.Telerik.com as well (which is also AJAX equipped).

Mark Brittingham
  • 28,545
  • 12
  • 80
  • 110
2

Not a control, but this is the way to implement paging at the DB level: SQL Server 2005 Paging

Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541
0

I have written a pager control named: Flexy Pager
Read more: http://www.codeproject.com/Articles/748270/Flexy-Pager-for-ASP-NET-WebForm-MVC

enter image description here

mjb
  • 7,649
  • 8
  • 44
  • 60
0

You can try NPager. Uses query string for page indexes, no postbacks. Needs Bootstrap for styling, however you can have your own custom css classes for the control using 'pagination' CSS class.Here is a working DEMO

enter image description here

Nabin Karki Thapa
  • 483
  • 1
  • 6
  • 18