ASP.NET存储过程实现分页效果(三层架构)
程序员文章站
2023-12-13 21:23:16
本文实例为大家分享了asp.net存储过程实现分页的具体代码,供大家参考,具体内容如下
实现效果:
文本框内输入跳转的页数,点击go会跳转到该页
首先在项目下加入...
本文实例为大家分享了asp.net存储过程实现分页的具体代码,供大家参考,具体内容如下
实现效果:
文本框内输入跳转的页数,点击go会跳转到该页
首先在项目下加入bll,dal,dataaccess,model类库
1、前台界面
<%@ page language="c#" autoeventwireup="true" codebehind="原始刷新分页.aspx.cs" inherits="分页.原始刷新分页" %> <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <script src="js/jquery1.7.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $('#txtpageindex').focus(function () { $(this).val(""); }) }) </script> </head> <body> <form id="form1" runat="server"> <div> <asp:gridview id="gridview1" runat="server" autogeneratecolumns="false"> <columns> <asp:boundfield datafield="id" headertext="编号" /> <asp:boundfield datafield="newstitle" headertext="新闻标题" /> <asp:boundfield datafield="newscontent" headertext="新闻内容" /> <asp:boundfield datafield="createtime" dataformatstring="{0:yyyy-mm-dd hh:mm:ss}" headertext="创建时间" /> </columns> </asp:gridview> </div> <div> <asp:linkbutton id="btnfirst" runat="server" onclick="btnfirst_click">第一页</asp:linkbutton> <asp:linkbutton id="btnpre" runat="server" onclick="btnpre_click">上一页</asp:linkbutton> <asp:linkbutton id="btnnext" runat="server" onclick="btnnext_click">下一页</asp:linkbutton> <asp:linkbutton id="btnlast" runat="server" onclick="btnlast_click">最后一页</asp:linkbutton><asp:textbox id="txtpageindex" runat="server"></asp:textbox> <asp:linkbutton id="linkbutton5" runat="server" onclick="linkbutton5_click">go</asp:linkbutton> </div> </form> </body> </html>
2、后台代码
using system; using system.collections.generic; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols; using system.data; namespace 分页 { public partial class 原始刷新分页 : system.web.ui.page { int pagesize = 10; protected void page_load(object sender, eventargs e) { if (!ispostback) { viewstate["pageindex"] = 1; getlastpageindex(); loaddata(); } } private void getlastpageindex() { bll.t_news1 bnews = new bll.t_news1(); int totalcount = bnews.getrecordcount(""); if (totalcount % pagesize == 0) { viewstate["lastpageindex"] = totalcount / pagesize; } else { viewstate["lastpageindex"] = totalcount / pagesize+1; } } private void loaddata() { bll.t_news1 bnews = new bll.t_news1(); datatable dt = bnews.getlistdatatable(pagesize,convert.toint32(viewstate["pageindex"])); this.gridview1.datasource = dt; this.gridview1.databind(); } protected void btnfirst_click(object sender, eventargs e) { viewstate["pageindex"] = 1; loaddata(); } protected void btnpre_click(object sender, eventargs e) { int pageindex = convert.toint32(viewstate["pageindex"]); if (pageindex > 1) { pageindex--; viewstate["pageindex"] = pageindex; loaddata(); } } protected void btnnext_click(object sender, eventargs e) { int pageindex = convert.toint32(viewstate["pageindex"]); if (pageindex < convert.toint32(viewstate["lastpageindex"])) { pageindex++; viewstate["pageindex"] = pageindex; loaddata(); } } protected void btnlast_click(object sender, eventargs e) { viewstate["pageindex"] = viewstate["lastpageindex"]; loaddata(); } protected void linkbutton5_click(object sender, eventargs e) { int result; if (int.tryparse(txtpageindex.text, out result) == true) { viewstate["pageindex"] = txtpageindex.text.trim(); loaddata(); } else { txtpageindex.text = "请输入合法的数字"; } } } }
3、数据库存储过程
declare @pagesize int; declare @pageindex int; select * from (select row_number() over(order by id) as rownumber,* from t_news1)t where rownumber>(@pageindex-1)*@pagesize and rownumber<=@pagesize*@pageindex go create proc pro_fenye @pagesize int, @pageindex int as select * from(select row_number() over(order by id) as rownumber,* from t_news1)t where rownumber>(@pageindex-1)*@pagesize and rownumber<=@pageindex*@pagesize go exec pro_fenye 2,5
以上就是本文的全部内容,希望对大家的学习有所帮助。