一个自定义分页功能的例子:
http://xml.sz.luohuedu.net/xml/ShowDetail.asp?id=B12283DE-DB20-4322-ACCC-12724442808A

解决方案 »

  1.   

    <% @ Page Language="C#" %>
    <% @ Import Namespace="System.Data" %>
    <% @ Import Namespace="System.Data.OleDb" %>
    <Script Language="C#" Runat="Server">
    OleDbConnection MyConn;
    public void Page_Load(Object src,EventArgs e)
    {
    //连接语句
    string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\db1.mdb;";
    MyConn = new OleDbConnection(MyConnString);
    MyConn.Open(); if(!Page.IsPostBack)
    {
    BindGrid();
    }
    }
    ICollection CreateTable()
    {
    string strSel = "select * from UserList";
    DataSet ds = new DataSet(); OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
    MyAdapter.Fill(ds,"Score"); return ds.Tables["Score"].DefaultView;
    }
    public void BindGrid()
    {
    DataView dv = (DataView)CreateTable();
    usrGrid.VirtualItemCount = dv.Count;
    usrGrid.DataSource = dv;
    usrGrid.DataBind();
    }public void DataGrid_PageChanged(Object sender,DataGridPageChangedEventArgs e)
    {
    usrGrid.CurrentPageIndex = e.NewPageIndex;
    BindGrid();
    }
    </script>
    <html>
    <head>
    <title></title>
    </head>
    <body>
    <form runat="server">
    <center>
    <b>演示DataGrid的CustomPaging</b>
    <asp:DataGrid id="usrGrid" runat="server"
    HeaderStyle-BackColor="#aaaadd"
    AlternatingItemStyle-BackColor="#eeeeee"
    AutoGenerateColumns="False"
    AllowPaging="True"
    AllowCustomPaging="True"
    PageSize="5"
    PagerStyle-Mode="NumericPages"
    PagerStyle-HorizontalAlign="Right"
    OnPageIndexChanged="DataGrid_PageChanged"
    >
    <Columns>
    <asp:BoundColumn HeaderText="ID号" DataField="id" />
    <asp:BoundColumn HeaderText="姓名" DataField="UserName" />
    <asp:BoundColumn HeaderText="年龄" DataField="Age" />
    <asp:BoundColumn HeaderText="主页" DataField="HomePage" />
    <asp:BoundColumn HeaderText="地址" DataField="Address" />
    </Columns>
    </asp:DataGrid>
    </center>
    </form>
    </body>
    </html>