使用存储过程在C#中实现分页实现(SQL 2000)

CREATE PROCEDURE GetPagedData
    @PageNumber INT,
    @PageSize INT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @StartRow INT, @EndRow INT
    SET @StartRow = (@PageNumber - 1) * @PageSize + 1
    SET @EndRow = @PageNumber * @PageSize

    SELECT *
    FROM (
        SELECT ROW_NUMBER() OVER (ORDER BY ID) AS RowNum, *
        FROM YourTable
    ) AS T
    WHERE RowNum BETWEEN @StartRow AND @EndRow
END

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand("GetPagedData", connection);
    command.CommandType = CommandType.StoredProcedure;
    command.Parameters.AddWithValue("@PageNumber", pageNumber);
    command.Parameters.AddWithValue("@PageSize", pageSize);

    connection.Open();
    SqlDataReader reader = command.ExecuteReader();

    while (reader.Read())
    {
        // 处理每一行数据
    }

    reader.Close();
}