分页控件

来源：互联网发布：json双引号自动加斜杠编辑：程序博客网时间：2024/04/28 09:32

//分页处理
    private void databind()
    {
        int curpage = Convert.ToInt32(this.Label1.Text);
        string sql = string.Format("select a.product_id,b.bigclass_name,a.product_title,a.product_time from product as a ,bigclass as b where a.bigclass_id=b.bigclass_id");
        DBConn conn = new DBConn();
        DataSet ds = conn.getDataSet(sql);
        PagedDataSource ps = new PagedDataSource();
        ps.DataSource = ds.Tables[0].DefaultView;
        ps.AllowPaging = true;
        ps.PageSize =10;
        ps.CurrentPageIndex = curpage - 1;
        btnfirst.Enabled = true;
        btnprev.Enabled = true;
        btnnext.Enabled = true;
        btnlast.Enabled = true;
        lbl_pagecount.Text = ps.PageCount.ToString();//共有多少页；
        lbl_pagesize.Text = ps.PageSize.ToString();//每页显示多少条；
        lbl_count.Text = Convert.ToString(ps.DataSourceCount.ToString()); //共有多少条信息

        if (ps.PageCount > 1)
        {
            if (ps.CurrentPageIndex == 0)
            {
                btnfirst.Enabled = false;
                btnprev.Enabled = false;
            }
            else if (ps.CurrentPageIndex > 1 && ps.CurrentPageIndex < ps.PageCount)
            {
                btnfirst.Enabled = true;
                btnprev.Enabled = true;
                btnnext.Enabled = true;
                btnlast.Enabled = true;
            }
            else if (ps.CurrentPageIndex == ps.PageCount - 1)
            {
                btnfirst.Enabled = true;
                btnprev.Enabled = true;
                btnnext.Enabled = false;
                btnlast.Enabled = false;
            }
        }
        else if (ps.PageCount == 1)
        {
            btnfirst.Enabled = false;
            btnprev.Enabled = false;
            btnnext.Enabled = false;
            btnlast.Enabled = false;
        }
        //if (curpage == 1)
        //{
        //    btnfirst.Enabled = false;
        //    btnprev.Enabled = false;
        //}
        //else if (curpage == ps.PageCount)
        //{
        //    btnfirst.Enabled = true;
        //    btnprev.Enabled = true;
        //    btnnext.Enabled = false;
        //    btnlast.Enabled = false;
        //}


        GridView1.DataSource = ps;
        GridView1.DataBind();