返回结果集分页
/// <summary>
/// 返回结果集分页
/// </summary>
/// <param name="cmdText">SQL语句</param>
/// <param name="start">起始条数(从0开始) start+1 -- start+max</param>
/// <param name="max">分页条数</param>
public DataTable GetDataTable_Page(string cmdText, int start, int max)
{
//创建连接
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
//创建一个新的数据适配器
SqlDataAdapter custDA = new SqlDataAdapter();
//创建一个新的 SqlCommand 对象
SqlCommand cmd = new SqlCommand();
cmd.CommandText = cmdText;
cmd.Connection = connection;
custDA.SelectCommand = cmd;
DataSet ds = new DataSet();
try
{
custDA.Fill(ds, start, max, "data");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return ds.Tables["data"];
}
}