datalist 或者repeater分页

     找了很久,终于找到了自己想要的分页效果
aspx:

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!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 id="Head1" runat="server">
    <title>无标题页</title>
    <style type="text/css">
   body{
     font:12px tahoma;
     background:#E4E8F3;
   }
   table{
        border-collapse:collapse;
   }
   th{
        background:#B8C0D3;
   }
   th,td{
        border:1px solid #8594B1;
   }
   td{
        height:25px;
        padding:5px;
        background:#EFF1F5;
   }
    a
   {
        color:#240589;
        text-decoration: none;
   }
   /* Pager Style Start */
.number span a
{
    font-size:12px;
      padding-top:4px;
      padding-bottom:4px;
      padding-left:6px;
      padding-right:6px;
}
.number span a:hover
{
    font-size: 12px;
    padding-top:4px;
      padding-bottom:4px;
      padding-left:6px;
      padding-right:6px;
    background-color: #3366cc;
    color:#FFFFFF;
}
.number
{
    margin-bottom:5px;
    margin-top:5px;
    font-size: 14px;
    font-weight: bold;
    color: #ff00ff;
}
.number span
{
    border:solid 1px #cccccc;
    background-color:#FFFFFF;
    color:#666666;
    font-size:12px;
    font-family:Verdana;
    line-height:20px;
    display:inline-block;
    margin-left:4px;
    margin-right:4px;
}
   </style>
</head>


<body>
    <form id="form1" runat="server">
    <script src="pager.js" type="text/javascript"></script>
    <div>
        <asp:Repeater ID="myRepeater" runat="server" OnItemCommand="Repeater1_ItemCommand">
        <HeaderTemplate>
        <table>
        <tr>
        <th>房</td>
        <th>厅</td>
        <th>厨</td>
        <th>ID</td>
        <th>名称</th>
        </tr>
        </HeaderTemplate>
        <ItemTemplate>
        <tr>
        <td><asp:Label ID="Label1" runat="server" Text='<%#Eval("room1","{0}") %>' /></td>
        <td><asp:Label ID="Label2" runat="server" Text='<%#Eval("room2","{0}") %>' /></td>
        <td><asp:Label ID="Label3" runat="server" Text='<%#Eval("room3","{0}") %>' /></td>
        <td><asp:Label ID="Label4" runat="server" Text='<%#Eval("id","{0}") %>' /></td>
        <td><asp:Label ID="Label5" runat="server" Text='<%#Eval("platename","{0}") %>' /></td>
        </tr>
        </ItemTemplate>
        <FooterTemplate>    
        </table>
        </FooterTemplate>
        </asp:Repeater>
    </div>
    <br />
    <script language="javascript" type="text/javascript">
    var pg = new showPages('pg');
    pg.pageCount = <%=PageCount %>;
    pg.printHtml();
    </script>
    </form>
</body>
</html>

 

CS:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    string pageCount;
    public string PageCount
    {
        get { return pageCount; }
        set { pageCount = value; }
    }
    int currentPage;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["Page"] != null)
            currentPage = Convert.ToInt32(Request.QueryString["Page"]);
        else
            currentPage = 1;

        CreateData(currentPage);

    }

    private void CreateData(int currentPage)
    {
        SqlConnection myConn = new SqlConnection("uid=sa;pwd=998113;database=mssqlsouwoo;server=192.168.0.135;");
        PagedDataSource ps = new PagedDataSource();
        myConn.Open();
        //定义一个OleDbDataAdapter
        SqlDataAdapter myAdapter = new  SqlDataAdapter("select top 500 * from [souwoo_adhouse]", myConn);
        DataSet ds = new DataSet();
        //填充数据
        myAdapter.Fill(ds);
        ps.DataSource = ds.Tables[0].DefaultView;
        ps.AllowPaging = true;
        ps.PageSize = 10;
        ps.CurrentPageIndex = currentPage - 1;
        pageCount = ps.PageCount.ToString();
        this.myRepeater.DataSource = ps;
        this.myRepeater.DataBind();
    }

    protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {

    }
}


 


pager.js

// JScript 文件

function showPages(name) { //初始化属性
    this.name = name;      //对象名称
    this.page = 1;         //当前页数
    this.pageCount = 1;    //总页数
    this.argName = 'page'; //参数名
    this.showTimes = 1;    //打印次数
}

showPages.prototype.getPage = function(){ //丛url获得当前页数,如果变量重复只获取最后一个
    var args = location.search;
    var reg = new RegExp('[\?&]?' + this.argName + '=([^&]*)[&$]?', 'gi');
    var chk = args.match(reg);
    this.page = RegExp.$1;
}
showPages.prototype.checkPages = function(){ //进行当前页数和总页数的验证
    if (isNaN(parseInt(this.page))) this.page = 1;
    if (isNaN(parseInt(this.pageCount))) this.pageCount = 1;
    if (this.page < 1) this.page = 1;
    if (this.pageCount < 1) this.pageCount = 1;
    if (this.page > this.pageCount) this.page = this.pageCount;
    this.page = parseInt(this.page);
    this.pageCount = parseInt(this.pageCount);
}
showPages.prototype.createHtml = function(){ //生成html代码
    var strHtml = '', prevPage = this.page - 1, nextPage = this.page + 1;
            strHtml += '<span class="count">Pages: ' + this.page + ' / ' + this.pageCount + '</span>';
            strHtml += '<span class="number">';
            if (prevPage < 1) {
                strHtml += '<span title="首页">«</span>';
                strHtml += '<span title="前一页">‹</span>';
            } else {
                strHtml += '<span title="首页"><a href="javascript:' + this.name + '.toPage(1);">«</a></span>';
                strHtml += '<span title="前一页"><a href="javascript:' + this.name + '.toPage(' + prevPage + ');">‹</a></span>';
            }
            if (this.page % 10 ==0) {
                var startPage = this.page - 9;
            } else {
                var startPage = this.page - this.page % 10 + 1;
            }
            if (startPage > 10) strHtml += '<span title="前十页"><a href="javascript:' + this.name + '.toPage(' + (startPage - 1) + ');">...</a></span>';
            for (var i = startPage; i < startPage + 10; i++) {
                if (i > this.pageCount) break;
                if (i == this.page) {
                    strHtml += '<span title="第' + i + '页">' + i + '</span>';
                } else {
                    strHtml += '<span title="第' + i + '页"><a href="javascript:' + this.name + '.toPage(' + i + ');">' + i + '</a></span>';
                }
            }
            if (this.pageCount >= startPage + 10) strHtml += '<span title="后10页"><a href="javascript:' + this.name + '.toPage(' + (startPage + 10) + ');">...</a></span>';
            if (nextPage > this.pageCount) {
                strHtml += '<span title="下一页">›</span>';
                strHtml += '<span title="上一页">»</span>';
            } else {
                strHtml += '<span title="下一页"><a href="javascript:' + this.name + '.toPage(' + nextPage + ');">›</a></span>';
                strHtml += '<span title="最后一页"><a href="javascript:' + this.name + '.toPage(' + this.pageCount + ');">»</a></span>';
            }
            strHtml += '</span><br />';
    return strHtml;
}
showPages.prototype.createUrl = function (page) { //生成页面跳转url
    if (isNaN(parseInt(page))) page = 1;
    if (page < 1) page = 1;
    if (page > this.pageCount) page = this.pageCount;
    var url = location.protocol + '//' + location.host + location.pathname;
    var args = location.search;
    var reg = new RegExp('([\?&]?)' + this.argName + '=[^&]*[&$]?', 'gi');
    args = args.replace(reg,'$1');
    if (args == '' || args == null) {
        args += '?' + this.argName + '=' + page;
    } else if (args.substr(args.length - 1,1) == '?' || args.substr(args.length - 1,1) == '&') {
            args += this.argName + '=' + page;
    } else {
            args += '&' + this.argName + '=' + page;
    }
    return url + args;
}
showPages.prototype.toPage = function(page){ //页面跳转
    var turnTo = 1;
    if (typeof(page) == 'object') {
        turnTo = page.options[page.selectedIndex].value;
    } else {
        turnTo = page;
    }
    self.location.href = this.createUrl(turnTo);
}
showPages.prototype.printHtml = function(){ //显示html代码
    this.getPage();
    this.checkPages();
    this.showTimes += 1;
    document.write('<div id="pages_' + this.name + '_' + this.showTimes + '" class="pages"></div>');
    document.getElementById('pages_' + this.name + '_' + this.showTimes).innerHTML = this.createHtml();
   
}
showPages.prototype.formatInputPage = function(e){ //限定输入页数格式
    var ie = navigator.appName=="Microsoft Internet Explorer"?true:false;
    if(!ie) var key = e.which;
    else var key = event.keyCode;
    if (key == 8 || key == 46 || (key >= 48 && key <= 57)) return true;
    return false;
}

 

但是,这几乎只是把.net中的控件分页重写了一遍,如果操作大容量数据库的时候,还是很笨的。需要改进,
谁有意见请发表!

原文地址:https://www.cnblogs.com/jackrebel/p/1088483.html