datalist分页pageddatasource

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }
    void bind()
    {
        int curpage = Convert.ToInt32(this.Label1.Text);
        PagedDataSource ps = new PagedDataSource();
        pagebind(ps);
        ps.AllowPaging = true;
        ps.PageSize = 5;
        ps.CurrentPageIndex = curpage -1;
        this.LinkButton1.Enabled = true;
        this.LinkButton2.Enabled = true;
        this.LinkButton3.Enabled = true;
        this.LinkButton4.Enabled = true;
        if (curpage == 1)
        {
            this.LinkButton1.Enabled = false;
            this.LinkButton2.Enabled = false;
        }
        if (curpage == ps.PageCount)
        {
            this.LinkButton3.Enabled = false;
            this.LinkButton4.Enabled = false;
        }
        this.Label2.Text = ps.PageCount.ToString();
        this.DataList1.DataSource = ps;
        this.DataList1.DataBind();


    }
    void pagebind(PagedDataSource pd)
    {
        string strcon="server=.;database=pubs;uid=sa;pwd=sa";
        SqlConnection cn = new SqlConnection(strcon);
        SqlDataAdapter da = new SqlDataAdapter("select title_id,title,price from titles", cn);
        DataSet ds = new DataSet();
        da.Fill(ds, "titles");
        pd.DataSource = ds.Tables["titles"].DefaultView;
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        this.Label1.Text = "1";
        bind();
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        this.Label1.Text = (Convert.ToInt32(this.Label1.Text) - 1).ToString();
        bind();
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        this.Label1.Text=(Convert.ToInt32(this.Label1.Text)+1).ToString();
        bind();
    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        this.Label1.Text = Label2.Text;
        bind();
    }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值