Êý¾Ý²ãÖ´Ðд洢¹ý³ÌµÄ·½·¨£¬ÄÚ²¿º¬ÓÐÊä³ö²ÎÊý

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;
}