public DataTable ProcGetPagedData(string procName, int pageIndex, int pageSize, out int pageCount, out int rowCount)
{
SqlConnection conn = new SqlConnection(connStr);
pageCount = 0;
rowCount = 0;
SqlDataAdapter sda = new SqlDataAdapter(procName, conn);
SqlParameter[] paras = new SqlParameter[]{
new SqlParameter("@pi",pageIndex),
new SqlParameter("@ps",pageSize),
new SqlParameter("@pc",pageCount),
new SqlParameter("@rc",rowCount)
};
paras[2].Direction = ParameterDirection.Output;
paras[3].Direction = ParameterDirection.Output;
sda.SelectCommand.Parameters.AddRange(paras);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
sda.Fill(dt);
pageCount = Convert.ToInt32(paras[2].Value); //接收存储过程的输出参数值
rowCount = Convert.ToInt32(paras[3].Value);
return dt;
}