c#.net存储过程版本的分页

 

protected void dataBind() {

int page = 1;

if (Request.QueryString["page"] != null){

page = Convert.ToInt32(Request["page"]);

}

if (Request.Form["page"] != null){

page = Convert.ToInt32(Request.Form["page"]);

}

int myPageSize = 20;

SqlConnection conn = new SqlConnection(dbTool.myConnStr);

SqlCommand cmd = new SqlCommand("p_page", conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@Tables", SqlDbType.VarChar, 50);

cmd.Parameters["@Tables"].Value = "testTable";

cmd.Parameters.Add("@PrimaryKey", SqlDbType.VarChar, 50);

cmd.Parameters["@PrimaryKey"].Value = "id";

cmd.Parameters.Add("@Sort", SqlDbType.VarChar, 50);

cmd.Parameters["@Sort"].Value = "id asc";

cmd.Parameters.Add("@CurrentPage", SqlDbType.Int, 4);

cmd.Parameters["@CurrentPage"].Value = page;

cmd.Parameters.Add("@PageSize", SqlDbType.Int, 4);

cmd.Parameters["@PageSize"].Value = myPageSize;

cmd.Parameters.Add("@Fields", SqlDbType.VarChar, 50);

Ҷƪл˵?