asp.net datalist+aspnetpager分页

来源：互联网发布：淘宝定时开拍怎么设置编辑：程序博客网时间：2024/05/10 21:30

最开始还要导入aspnetpager的.dll文件到bin文件夹下

最前引用：

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

前台：

    <asp:DataList ID="DataList1" runat="server" Width="178px">
        <ItemTemplate>
            <asp:Label ID="Label1" runat="server" Text='<%# Eval("title") %>'></asp:Label>
        </ItemTemplate>
    </asp:DataList>
    <webdiyer:aspnetpager id="pager1" runat="server" NumericButtonCount="3" PageSize="2" AlwaysShow="true" FirstPageText=" 首页 "
　　LastPageText=" 尾页 " NextPageText=" 下一页 " PrevPageText=" 上一页 " CssClass="paginator" UrlPaging="True" OnPageChanged="pager1_PageChanged" PageIndexBoxType="DropDownList" ShowPageIndexBox="Always" ></webdiyer:aspnetpager>

PageIndexBoxType有dropdownlist和textbox可选

样式：

.paginator { font: 11px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;margin-right:2px}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {padding: 1px 6px;font-weight: bold; font-size: 13px;border:none}
.paginator a:hover {color: #fff; background: #ffa501;border-color:#ffa501;text-decoration: none;}

后台：

DBConn conn=new DBConn();

public void datalist()

{    string str = "select * from T_dongtai";
        DataSet st = conn.getds(str);
        PagedDataSource psd = new PagedDataSource();
        psd.DataSource = st.Tables[0].DefaultView;
        pager1.RecordCount = st.Tables[0].DefaultView.Count;
        psd.AllowPaging = true;
        psd.CurrentPageIndex = pager1.CurrentPageIndex - 1;
        psd.PageSize = pager1.PageSize;

DataList1.DataSource = psd;
DataList1.DataBind();

}

    protected void pager1_PageChanged(object sender, EventArgs e)
    {
        datalist();
    }

还要有一个方法：

类DBConn里的getds方法：

public DataSet getds(string sql)
    {
        OleDbConnection conn = getCon();
        OleDbDataAdapter dsa = new OleDbDataAdapter(sql, conn);
        DataSet st = new DataSet();
        dsa.Fill(st);
        return st;
    }