<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
下面是存储过程：
CREATE PROCEDURE newsPaged
(
@PageIndex int,
@PageSize int
)
AS
BEGIN
DECLARE @PageLowerBound int
DECLARE @PageUpperBound int
DECLARE @RowsToReturn int
-- First set the rowcount
SET @RowsToReturn = @PageSize * (@PageIndex + 1)
SET ROWCOUNT @RowsToReturn
-- Set the page bounds
SET @PageLowerBound = @PageSize * @PageIndex
SET @PageUpperBound = @PageLowerBound + @PageSize + 1
-- Create a temp table to store the select results
CREATE TABLE #PageIndex
(
IndexId int IDENTITY (1, 1) NOT NULL,
ArticleID int,
)
-- Insert into the temp table
INSERT INTO #PageIndex (ArticleID)
SELECT
ArticleID
FROM
tablename
ORDER BY
ArticleID DESC
-- Return total count
SELECT COUNT(ArticleID) FROM tablename
-- Return paged results
SELECT
O.ArticleID,O.Topic,Editor
FROM
tablename O,
#PageIndex PageIndex
WHERE
O.ArticleID = PageIndex.ArticleID AND
PageIndex.IndexID > @PageLowerBound AND
PageIndex.IndexID < @PageUpperBound
ORDER BY
PageIndex.IndexID
END