Individual pager with repeater and SQL

Question

I was looking for a good tutorial to teach me how to set up individual paging control with a simple DataBound control, such as Repeater, to implement a high-performance paging function.

I found many articles about this problem, but not one of them was the complete answer.

• Paging Great Results in ASP.NET

  This is awesome, with statistics and an excellent comparison between the various ways of this, but the problem is that it is too old before SQL Server received the new ROW_NUMBER () function

• N-layered web applications with ASP.NET 3.5 Part 4: Sorting, Paging and Filtering (swap database) Section and ignore the rest)

  This is almost perfect, but he used a grid, the existing paging function, with a custom swap method instead of a repeater.

• Custom search engine optimized search query Repeater ASP.NET or DataList control

  I think this is too complicated and everything can be simplified.

I use SQL, Item Repeater (with direct binding in the code, without using data sources), PageNumbers repeater (which will have a link as an ItemTemplate to transmit the request so that the method used can get the next part of the Elements), Label to hold the current page number and title.

N-Layered Web Applications ASP.NET 3.5 4: , ( ). SQL Data Access Lyaer, :

WITH Records AS ( SELECT ItemId, ItemName, ROW_NUMBER() OVER (ORDER BY ItemId) AS 'RowNumber' FROM   Items)  SELECT * FROM Records WHERE (RowNumber BETWEEN (@startIndex) AND @startIndex + @pageSize - 1)

, !

Answer 1

pagination. :

    /// <summary>
    /// Produces html for a pagination control.
    /// </summary>
    /// <param name="page">Page number for the current page (1-based index).</param>
    /// <param name="pageSize">Number or items per page.</param>
    /// <param name="totalItems">Total number of items across all pages.</param>
    /// <returns>Html of a pagination control.</returns>
    public string RenderPaginationControl(int page, int pageSize, int totalItems)
    {
        int totalPages = (int)Math.Ceiling((double)totalItems/pageSize);

        // Create pager.
        StringBuilder pagerSb = new StringBuilder();
        for (int i = 1; i <= totalPages; ++i)
        {
            // If it is NOT a link to current page.
            if (i != page) { pagerSb.Append(string.Format("<a href='/data.aspx?page={0}'>{0}</a>", i)); }
            // If it is the link to current page.
            else { pagerSb.Append(string.Format("<span>{0}</span>", i)); }
        }

        return pagerSb.ToString();
    }

sql,

SELECT COUNT(*) FROM Items

totalItems RenderPaginationControl.

Repeater, :

this.MyRepeater.DataSource = DAL.GetItems(page, pageSize);
this.MyRepeater.DataBind();

int totalItems = DAL.GetTotalNumberOfItems();
this.PaginationLabel.Text = RenderPaginationControl(page, pageSize, totalItems);