`
流星剑
  • 浏览: 91806 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

利用pageDataSource实现页面的分页

    博客分类:
  • .net
阅读更多
前台代码:<div id="showTfenye">					
                当前页:<asp:Label ID="lblPage" runat="server" Text="1"></asp:Label>&nbsp;&nbsp;&nbsp;&nbsp;
                总页数:<asp:Label ID="lblBackPage" runat="server" Text=""></asp:Label>&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:LinkButton ID="lbtnOne" runat="server" ForeColor="Red" 
                    onclick="lbtnOne_Click">首页</asp:LinkButton>&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:LinkButton ID="lbtnUp" runat="server" ForeColor="Red" 
                    onclick="lbtnUp_Click">上一页</asp:LinkButton>&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:LinkButton ID="lbtnNext" runat="server" ForeColor="Red" 
                    onclick="lbtnNext_Click">下一页</asp:LinkButton>&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:LinkButton ID="lbtnBack" runat="server" ForeColor="Red" 
                    onclick="lbtnBack_Click">末页</asp:LinkButton>&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:DropDownList ID="DropDownList1" runat="server" Width="40px">                    
                    </asp:DropDownList>&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:Button ID="Button1" runat="server" Text="Go" BackColor="#99FFCC" 
                        BorderColor="#3333FF" BorderWidth="2px" onclick="Button1_Click" />   
				</div>
 #region 取出资源名称
    /// <summary>
    /// 取出资源名称
    /// </summary>
    /// <returns></returns>
    public DataTable selectSouName()
    {
        string sqlcon = "select  * from 资源中心";
        CommandType ct = CommandType.Text;
        sqlh = new SQLHelper();
        DataTable dt = new DataTable();
        dt = sqlh.ExecuteQuery(sqlcon, ct);
        return dt;
    }
    #endregion
    #region  分页
    /// <summary>
    /// 分页
    /// </summary>
    protected void bind()
    {
        //获得当前的页码
        int curPage = Convert.ToInt32(this.lblPage.Text);
        //使用PageDataSource类实现datalist控件的分页
        PagedDataSource ps = new PagedDataSource();
        //获取数据
        DataTable dt = selectSouName();
        ps.DataSource = dt.DefaultView;
        //是否可以分页
        ps.AllowPaging = true;
        //显示分页的数量
        ps.PageSize = 8;
        //取得当前页的页码
        ps.CurrentPageIndex = curPage - 1;
        this.lbtnUp.Enabled = true;
        this.lbtnNext.Enabled = true;
        this.lbtnBack.Enabled = true;
        this.lbtnOne.Enabled = true;
        if (curPage == 1)
        {
            //不显示第一页按钮
            this.lbtnOne.Enabled = false;
            //不显示上一页按钮
            this.lbtnUp.Enabled = false;
        }
        if (curPage == ps.PageCount)
        {
            //不显示下一页按钮
            this.lbtnNext.Enabled = false;
            //不显示最后一页按钮
            this.lbtnBack.Enabled = false;
        }
        //显示分页数量
        this.lblBackPage.Text = Convert.ToString(ps.PageCount);
        //绑定datalist控件
        this.dlTitle.DataSource = ps;
        this.dlTitle.DataKeyField = "caID";
        this.dlTitle.DataBind();
    }
    #endregion
    #region 第一页
    /// <summary>
    /// 第一页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void lbtnOne_Click(object sender, EventArgs e)
    {
        this.lblPage.Text = "1";
        this.bind();
    }
    #endregion
    #region 上一页
    /// <summary>
    /// 上一页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void lbtnUp_Click(object sender, EventArgs e)
    {
        this.lblPage.Text = Convert.ToString(Convert.ToInt32(this.lblPage.Text) - 1);
        this.bind();
    }
    #endregion
    #region 下一页
    /// <summary>
    /// 下一页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void lbtnNext_Click(object sender, EventArgs e)
    {
        this.lblPage.Text = Convert.ToString(Convert.ToInt32(this.lblPage.Text) + 1);
        this.bind();
    }
    #endregion
    #region 最后一页
    /// <summary>
    /// 最后一页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void lbtnBack_Click(object sender, EventArgs e)
    {
        this.lblPage.Text = this.lblBackPage.Text;
        this.bind();
    }
    #endregion 
//显示所有页数
    public void showPage()
    {
        int count =Convert.ToInt32(lblBackPage.Text) ;
        int []num=new int[count];
        for (int i = 1; i <=count; i++)
        {
            num[i-1] = i;
            //DropDownList1.DataValueField = i.ToString();//指定下拉列表中的值部分 
        }
        DropDownList1.DataSource = num;
        DropDownList1.DataBind();
    }
    //跳转到指定页
    protected void Button1_Click(object sender, EventArgs e)
    {
        string  page = DropDownList1.SelectedValue;
        lblPage.Text = page;
        bind();
    }

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics