public static void QueryList()
{
SqlConnection con = new SqlConnection(" ");
SqlCommand cmd = new SqlCommand(" ", con);
//
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] para ={
new SqlParameter(" 1",SqlDbType.Int),
new SqlParameter(" 2",SqlDbType.Int),
new SqlParameter(" 3",SqlDbType.Int),
new SqlParameter(" 4",SqlDbType.Int)
};
para[0].Value = 3;
para[1].Value = 4;
para[2].Direction = ParameterDirection.Output; //
para[3].Direction = ParameterDirection.Output;
cmd.Parameters.AddRange(para);//
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine(dr[0].ToString());
}
int pageCount = Convert.ToInt32(cmd.Parameters[2].Value);
int rowCount = Convert.ToInt32(cmd.Parameters[3].Value);
Console.WriteLine("PageCount=" + pageCount + ",rowCount=" + rowCount);
}