最近在网上看了像google 差不多的分页,之后从网上参考了别人写的例子就写了下面的demo ,希望对大家有用、
在页面上 添加上个dataList 和 div 里面放显示的页数:
<form id="form1" runat="server"> <div> <asp:DataList ID="DataList1" runat="server"> <ItemTemplate> <asp:Label runat="server" ID="lblId" Text='<%#Eval("id")%>'></asp:Label> <asp:Label runat="server" ID="lblName" Text='<%#Eval("name") %>'></asp:Label> </ItemTemplate> </asp:DataList> <div id="PageInfo" runat="server" /> </div> </form>
调用主方法实现分页效果:
if (!Page.IsPostBack) { SqlConnection conn = new SqlConnection("server=LENOVO-FA00398C;database=AA;uid=sa;pwd=sasa"); string sql = "select * from Info "; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sql,conn); da.Fill(ds, "userInfo"); this.PageInfo.InnerHtml = GetPageNum(ds, DataList1, 2);//2是每页显示的条数 }
之后下面的就是后台主方法代码:
/// </summary> /// <param name="ds">DataSet实例</param> /// <param name="datalistname">DataList名称</param> /// <param name="pagesize">分页大小</param> public static string GetPageNum(DataSet ds, DataList datalistname, int pagesize) { PagedDataSource objPds = new PagedDataSource(); objPds.DataSource = ds.Tables[0].DefaultView; objPds.AllowPaging = true; int total = ds.Tables[0].Rows.Count; objPds.PageSize = pagesize; int page; if (HttpContext.Current.Request.QueryString["page"] != null) page = Convert.ToInt32(HttpContext.Current.Request.QueryString["page"]); else page = 1; objPds.CurrentPageIndex = page - 1; datalistname.DataSource = objPds; datalistname.DataBind(); int allpage = 0; int next = 0; int pre = 0; int startcount = 0; int endcount = 0; string pagestr = ""; if (page < 1) { page = 1; } //计算总页数 if (pagesize != 0) { allpage = (total / pagesize); allpage = ((total % pagesize) != 0 ? allpage + 1 : allpage); allpage = (allpage == 0 ? 1 : allpage); } next = page + 1; pre = page - 1; startcount = (page + 5) > allpage ? allpage - 9 : page - 4;//中间页起始序号 //中间页终止序号 endcount = page < 5 ? 10 : page + 5; if (startcount < 1) { startcount = 1; } //为了避免输出的时候产生负数,设置如果小于1就从序号1开始 if (allpage < endcount) { endcount = allpage; } //页码+5的可能性就会产生最终输出序号大于总页码,那么就要将其控制在页码数之内 pagestr = "共" + allpage + "页 "; pagestr += page > 1 ? "<a href="/" mce_href="/""" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=1/">首页</a> <a href="/" mce_href="/""" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + pre + "/">上一页</a>" : "首页 上一页"; //中间页处理,这个增加时间复杂度,减小空间复杂度 for (int i = startcount; i <= endcount; i++) { pagestr += page == i ? " <font color=/"#ff0000/">" + i + "</font>" : " <a href="/" mce_href="/""" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + i + "/">" + i + "</a>"; } pagestr += page != allpage ? " <a href="/" mce_href="/""" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + next + "/">下一页</a> <a href="/" mce_href="/""" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + allpage + "/">末页</a>" : " 下一页 末页"; return pagestr; }
最后 实现的效果如下图:
注: 这个是从别人那里拷过来的,不算侵犯版权吧。呵呵、、
本站转载的文章为个人学习借鉴使用,本站对版权不负任何法律责任。如果侵犯了您的隐私权益,请联系我们删除。
添加到收藏夹 *