PagedDataSource 分页

最新推荐文章于 2017-10-11 14:00:00 发布

wanghuaide

最新推荐文章于 2017-10-11 14:00:00 发布

阅读量1.3k

点赞数

分类专栏： asp.net 文章标签： server delete session mobile asp 手机

本文链接：https://blog.csdn.net/wanghuaide/article/details/3655656

版权

asp.net 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

源文件

 
   <asp:DataGrid  ID="dgMemberInfo" runat="server" Width="100%" DataKeyField="UserName" AutoGenerateColumns="false" OnDeleteCommand="dgMemberInfo_DeleteCommand" OnItemDataBound="dgMemberInfo_ItemDataBound">
               <Columns>  
                    <asp:BoundColumn DataField="UserName" HeaderText="用户名"></asp:BoundColumn>
                    <asp:BoundColumn DataField="RealName" HeaderText="真实姓名"></asp:BoundColumn>                                     
                    <asp:BoundColumn DataField="BranchId" HeaderText="部门"></asp:BoundColumn>
                    <asp:BoundColumn DataField="BranchMaster" HeaderText="负责的部门"></asp:BoundColumn>                                                          
                    <asp:BoundColumn DataField="State" HeaderText="是否禁用"></asp:BoundColumn> 
                    <asp:BoundColumn DataField="Sex" HeaderText="性别"></asp:BoundColumn>                   
                    <asp:BoundColumn DataField="Mobile" HeaderText="手机号"></asp:BoundColumn>                   
                    <asp:BoundColumn DataField="Elevel" HeaderText="学历"></asp:BoundColumn>
                    <asp:BoundColumn DataField="AddTime" HeaderText="添加时间"></asp:BoundColumn>                                                    
                    <asp:HyperLinkColumn Text="详情" DataNavigateUrlField="id" DataNavigateUrlFormatString="showmemberde.aspx?ID={0} "
                            HeaderText="详情"  Target="_blank"></asp:HyperLinkColumn>
                   <asp:HyperLinkColumn Text="修改"  DataNavigateUrlField="id" DataNavigateUrlFormatString="modifymember.aspx?ID={0} "
                            HeaderText="修改"  Target="_blank"></asp:HyperLinkColumn>                 
                    <asp:TemplateColumn HeaderText="禁/启用">
                                        <ItemTemplate>
                                            <asp:LinkButton Runat="server" ID="LB_LinkURLDelete" CommandName="Delete" OnClientClick="return confirm('确认要禁/启用该员工吗？');">禁/启用</asp:LinkButton>
                                        </ItemTemplate>                                     
                                    </asp:TemplateColumn>                                    
               </Columns>                                                           
                <ItemStyle HorizontalAlign="Left" />
                <HeaderStyle BackColor="#666699" BorderColor="Lime" Font-Bold="True" Font-Size="Medium"
                    Height="20px" ForeColor="White" />
            </asp:DataGrid>
            <asp:Label ID="lblMessage" runat="server" Text="Label"></asp:Label> 
            <asp:Label ID="lblCurrentPage" runat="server"></asp:Label><br />
            <asp:LinkButton ID="lbFirst" runat="server" OnClick="lbFirst_Click">第一页</asp:LinkButton> 
            <asp:LinkButton ID="lbPre" runat="server" OnClick="lbPre_Click">上一页</asp:LinkButton> 
            <asp:LinkButton ID="lbNext" runat="server" OnClick="lbNext_Click">下一页</asp:LinkButton> 
            <asp:LinkButton ID="lbLast" runat="server" OnClick="lbLast_Click">最后一页</asp:LinkButton><br />
 
   
 
  

.cs文件

 
   public static PagedDataSource Pds;   //注意这里定义
public void DataBind(DataTable dt)
    {
        Pds = new PagedDataSource();
        // mop.ShowIpTime(Session["jur"].ToString(), Convert.ToDateTime(todayDate)).DefaultView
        Pds.DataSource = dt.DefaultView;
        int recCount = Pds.Count;//总的记录数
        Pds.AllowPaging = true;
        Pds.PageSize = 25;//每页显示25条记录
        int pageCount = Pds.PageCount;  //页数
        this.lblMessage.Text = "(共<font color='red'>" + recCount.ToString() + "</font>条记录  <font color='red'>" + pageCount.ToString() + "</font>页)";
        this.lblCurrentPage.Text = "当前第<font color='red'>" + (Pds.CurrentPageIndex + 1).ToString() + "</font>页";
        dgMemberInfo.DataSource = Pds;
        dgMemberInfo.DataBind();
    }
protected void lbFirst_Click(object sender, EventArgs e)
    {
        Pds.CurrentPageIndex = 0;
        this.dgMemberInfo.DataSource = Pds;
        this.dgMemberInfo.DataBind();
        this.lbFirst.Enabled = false;
        this.lbPre.Enabled = false;
        this.lbNext.Enabled = true;
        this.lbLast.Enabled = true;
        this.lblCurrentPage.Text = "当前第<font color='red'>" + (Pds.CurrentPageIndex + 1).ToString() + "</font>页";
    }
    protected void lbPre_Click(object sender, EventArgs e)
    {
        if (Pds.CurrentPageIndex > 0)
        {
            if (Pds.CurrentPageIndex == Pds.PageCount - 1)
            {
                this.lbNext.Enabled = true;
                this.lbLast.Enabled = true;
            }
            Pds.CurrentPageIndex--;
            this.dgMemberInfo.DataSource = Pds;
            this.dgMemberInfo.DataBind();
            this.lblCurrentPage.Text = "当前第<font color='red'>" + (Pds.CurrentPageIndex + 1).ToString() + "</font>页";
            
        }
        //else
        if (Pds.CurrentPageIndex == 0)
        {
            this.lbFirst.Enabled = false;
            this.lbPre.Enabled = false;
        }
    }
    protected void lbNext_Click(object sender, EventArgs e)
    {
        if (Pds.CurrentPageIndex < Pds.PageCount - 1)
        {
            if (Pds.CurrentPageIndex == 0)
            {
                this.lbPre.Enabled = true;
                this.lbFirst.Enabled = true;
            }
            Pds.CurrentPageIndex++;
            this.dgMemberInfo.DataSource = Pds;
            this.dgMemberInfo.DataBind();
            this.lblCurrentPage.Text = "当前第<font color='red'>" + (Pds.CurrentPageIndex + 1).ToString() + "</font>页";           
        }
        //else
        if (Pds.CurrentPageIndex==Pds.PageCount - 1)
        {
            this.lbNext.Enabled = false;
            this.lbLast.Enabled = false;
        }
    }
    protected void lbLast_Click(object sender, EventArgs e)
    {
        Pds.CurrentPageIndex = Pds.PageCount - 1;
        this.dgMemberInfo.DataSource = Pds;
        this.dgMemberInfo.DataBind();
        this.lbNext.Enabled = false;
        this.lbLast.Enabled = false;
        this.lbFirst.Enabled = true;
        this.lbPre.Enabled = true;
        this.lblCurrentPage.Text = "当前第<font color='red'>" + (Pds.CurrentPageIndex + 1).ToString() + "</font>页";
    }
 
  