如何在C#中实现SQL Server的分页查询

在C#中实现SQL Server的分页查询，可以使用以下几种方法：

使用ROW_NUMBER()函数：

using System;using System.Data.SqlClient;namespace SqlServerPagination{    class Program    {        static void Main(string[] args)        {            string connectionString = "your_connection_string";            int pageNumber = 1;            int pageSize = 10;            using (SqlConnection connection = new SqlConnection(connectionString))            {                connection.Open();                string sql = $@"                    SELECT * FROM (                        SELECT *, ROW_NUMBER() OVER (ORDER BY Id) AS RowNumber                        FROM YourTable                    ) AS PagedTable                    WHERE RowNumber BETWEEN ((@PageNumber - 1) * @PageSize + 1) AND (@PageNumber * @PageSize)";                using (SqlCommand command = new SqlCommand(sql, connection))                {                    command.Parameters.AddWithValue("@PageNumber", pageNumber);                    command.Parameters.AddWithValue("@PageSize", pageSize);                    using (SqlDataReader reader = command.ExecuteReader())                    {                        while (reader.Read())                        {                            Console.WriteLine($"Id: {reader["Id"]}, Name: {reader["Name"]}");                        }                    }                }            }        }    }}

使用OFFSET和FETCH子句（仅适用于SQL Server 2012及更高版本）：

using System;using System.Data.SqlClient;namespace SqlServerPagination{    class Program    {        static void Main(string[] args)        {            string connectionString = "your_connection_string";            int pageNumber = 1;            int pageSize = 10;            using (SqlConnection connection = new SqlConnection(connectionString))            {                connection.Open();                string sql = $@"                    SELECT *                    FROM YourTable                    ORDER BY Id                    OFFSET (@PageNumber - 1) * @PageSize ROWS                    FETCH NEXT @PageSize ROWS ONLY";                using (SqlCommand command = new SqlCommand(sql, connection))                {                    command.Parameters.AddWithValue("@PageNumber", pageNumber);                    command.Parameters.AddWithValue("@PageSize", pageSize);                    using (SqlDataReader reader = command.ExecuteReader())                    {                        while (reader.Read())                        {                            Console.WriteLine($"Id: {reader["Id"]}, Name: {reader["Name"]}");                        }                    }                }            }        }    }}

请注意，将your_connection_string替换为你的SQL Server连接字符串，并将YourTable替换为你要查询的表名。这两个示例都使用了分页参数pageNumber和pageSize，你可以根据需要调整这些值。