[Classic ASP]Paged[Prev 1 2 3 4 5 Next]

 

[Paged]

<%

' set some variables

currentPage = CInt(Request.QueryString("page"))

itemsPerPage = 10

totalItems = 100

totalPages = Ceiling(totalItems / itemsPerPage)

' create paging links

previousPage = currentPage - 1

nextPage = currentPage + 1

' make sure previous and next links don't go out of bounds

If previousPage < 1 Then previousPage = 1

If nextPage > totalPages Then nextPage = totalPages

' output paging links

Response.Write("<div>")

Response.Write("<a href=""?page=" & previousPage & """>prev</a> ")

For i = 1 To totalPages

  If i = currentPage Then

    Response.Write("<b>" & i & "</b> ")

  Else

    Response.Write("<a href=""?page=" & i & """>" & i & "</a> ")

  End If

Next

Response.Write("<a href=""?page=" & nextPage & """>next</a>")

Response.Write("</div>")

%>

[Query]

DECLARE @PageNumber INT = 2;

DECLARE @PageSize INT = 10;

WITH OrderedData AS (

    SELECT ROW_NUMBER() OVER (ORDER BY SomeColumn) AS RowNumber, *

    FROM SomeTable

)

SELECT *

FROM OrderedData

WHERE RowNumber BETWEEN (@PageNumber - 1) * @PageSize + 1 AND @PageNumber * @PageSize;