2023年6月21日发(作者：)

C#调⽤存储过程实现分页（个⼈代码笔记）分页的存储过程：drop proc LoadPageMaincreate Proc LoadPageMain@pageIndex int,@pageSize int,@count int outasselect top(@pageSize) * from entwhere Fid not in( select top(@pageSize*(@pageIndex-1)) Fid from ent order by Fid)order by Fidselect @count=COUNT(1) from entDAL层调⽤分页存储过程： public List getPagedList(int pageIndex, int pageSize, out int count) { List modelList = new List(); //创建最终要返回的model 的 List集合对象 string connStr = "server=.;database=CCDB;uid=sa;pwd=130988825"; using (SqlConnection conn = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand()) //创建command对象 { tion = conn;

dType = Procedure; 设置command 对象的type属性 dText = "LoadPageMain"; //指定相应的存储过程 (new SqlParameter("@pageIndex",pageIndex)); //为存储过程添加参数 (new SqlParameter("@pageSize",pageSize)); SqlParameter outCount = new SqlParameter("@count",); //创建将要输出的参数，并添加到参数集合中 ion = ; (outCount); (); using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) //⽤SqlDataReader 对象回去数据，不⽤担⼼conn断开的问题 { DataSet ds = new DataSet();

(ds); //获取存储过程返回的数据集 count = (int); // 注意：获取 存储过程输出的参数值 foreach (DataRow row in [0].Rows )

{ ent model = new ent();

= ng(row[1]); = 32(row[2]); r = ng(row[3]); = row[4] is DBNull?null: (int?)32(row[4]); sh = 32(row[5]); Id = 32(row[6]); day = Time(row[7]); (model); } } } } return modelList; }aspx页⾯输出分页的⽅式： 在后台拼接字符串（数据输出的、分页连接的）输出到前台，后台通过前台传来的pageIndex、pageSize参数来动态改变数据 protected void Page_Load(object sender, EventArgs e) { int count = 0; int pageIndex = Request["pageIndex"]==null?1:32(Request["pageIndex"]); int pageSize = Request["pageSize"]==null?20:32(Request["pageSize"]);

ent bll_mystudent = new ent(); List modelList= bll_edList(pageIndex, pageSize, out count); StringBuilder sb = new StringBuilder(); for (int i = 0; i < ; i++) { ((" " + modelList[i].FName + " " + modelList[i].FAge + " " + modelList[i].FGender + " " + modelList[i].FMath + " " + modelList修改 删除 详情 ")); } trBody = ng(); int pageCount=(count-1)/pageSize+1; StringBuilder sbFY = new StringBuilder(); ("上⼀页 "); for (int i = 0; i < pageCount; i++) { (("{0}   ", i, i)); } ("下⼀页 "); strFY = ng(); }

2023年6月21日发(作者：)

C#调⽤存储过程实现分页（个⼈代码笔记）分页的存储过程：drop proc LoadPageMaincreate Proc LoadPageMain@pageIndex int,@pageSize int,@count int outasselect top(@pageSize) * from entwhere Fid not in( select top(@pageSize*(@pageIndex-1)) Fid from ent order by Fid)order by Fidselect @count=COUNT(1) from entDAL层调⽤分页存储过程： public List getPagedList(int pageIndex, int pageSize, out int count) { List modelList = new List(); //创建最终要返回的model 的 List集合对象 string connStr = "server=.;database=CCDB;uid=sa;pwd=130988825"; using (SqlConnection conn = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand()) //创建command对象 { tion = conn;

dType = Procedure; 设置command 对象的type属性 dText = "LoadPageMain"; //指定相应的存储过程 (new SqlParameter("@pageIndex",pageIndex)); //为存储过程添加参数 (new SqlParameter("@pageSize",pageSize)); SqlParameter outCount = new SqlParameter("@count",); //创建将要输出的参数，并添加到参数集合中 ion = ; (outCount); (); using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) //⽤SqlDataReader 对象回去数据，不⽤担⼼conn断开的问题 { DataSet ds = new DataSet();

(ds); //获取存储过程返回的数据集 count = (int); // 注意：获取 存储过程输出的参数值 foreach (DataRow row in [0].Rows )

{ ent model = new ent();

= ng(row[1]); = 32(row[2]); r = ng(row[3]); = row[4] is DBNull?null: (int?)32(row[4]); sh = 32(row[5]); Id = 32(row[6]); day = Time(row[7]); (model); } } } } return modelList; }aspx页⾯输出分页的⽅式： 在后台拼接字符串（数据输出的、分页连接的）输出到前台，后台通过前台传来的pageIndex、pageSize参数来动态改变数据 protected void Page_Load(object sender, EventArgs e) { int count = 0; int pageIndex = Request["pageIndex"]==null?1:32(Request["pageIndex"]); int pageSize = Request["pageSize"]==null?20:32(Request["pageSize"]);

ent bll_mystudent = new ent(); List modelList= bll_edList(pageIndex, pageSize, out count); StringBuilder sb = new StringBuilder(); for (int i = 0; i < ; i++) { ((" " + modelList[i].FName + " " + modelList[i].FAge + " " + modelList[i].FGender + " " + modelList[i].FMath + " " + modelList修改 删除 详情 ")); } trBody = ng(); int pageCount=(count-1)/pageSize+1; StringBuilder sbFY = new StringBuilder(); ("上⼀页 "); for (int i = 0; i < pageCount; i++) { (("{0}   ", i, i)); } ("下⼀页 "); strFY = ng(); }