PagedDataSource分页

--------DataList分页-------
private void indexListBind()
    {
        try
        {
            string parID = Request.QueryString["id"].ToString();
            int curPage = Convert.ToInt32(this.lb_pageIndex.Text) - 1;//获取当前页码,我用的是一个lable.当了中间变量
            con = Admin_DB.getConn();
            con.Open();
            DataSet ds = new DataSet();
            string Path = "~";
            OleDbDataAdapter sda = new OleDbDataAdapter("select ID,'" + Path + "'+imagePath as imagePath,introduce from D_Picture where parID=@parID", con);
            sda.SelectCommand.Parameters.Add(new OleDbParameter("@parID", parID));
            sda.Fill(ds, "index");
            System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();//实例化分页数据源
            ps.DataSource = ds.Tables["index"].DefaultView;//将要绑定在datalist上的datatable给分页数据源
            ps.AllowPaging = true;
            ps.PageSize = 8;//每页显示几条记录
            ps.CurrentPageIndex = curPage;//设置当前页的索引(当前页码减1就是)
            this.btn_up.Enabled = true;
            this.btn_next.Enabled = true;
            this.btn_frist.Enabled = true;
            this.btn_end.Enabled = true;
            endPage = ps.PageCount;
            if (curPage == 0)//当是第一页是.上一页和首页的按钮不可用
            {
                this.btn_up.Enabled = false;
                this.btn_frist.Enabled = false;
            }
            if (curPage == ps.PageCount - 1)//当是最后一页时下一页和最后一页的按钮不可用
            {
                this.btn_next.Enabled = false;
                this.btn_end.Enabled = false;
            }
            this.indexList.DataSource = ps;
            this.indexList.DataKeyField = "ID";
            this.indexList.DataBind();
            con.Close();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }

    }
    protected void btn_frist_Click(object sender, EventArgs e)
    {
        this.lb_pageIndex.Text = "1";
        this.indexListBind();
    }
    protected void btn_up_Click(object sender, EventArgs e)
    {
        int page = int.Parse(this.lb_pageIndex.Text) - 1;
        this.lb_pageIndex.Text = page.ToString();
        this.indexListBind();
    }
    protected void btn_next_Click(object sender, EventArgs e)
    {
        int page = int.Parse(this.lb_pageIndex.Text) + 1;
        this.lb_pageIndex.Text = page.ToString();
        this.indexListBind();
    }
    protected void btn_end_Click(object sender, EventArgs e)
    {
        this.lb_pageIndex.Text = endPage.ToString();
        this.indexListBind();
    }
 

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值