datalist分页pageddatasource

来源:互联网 发布:java web微信支付demo 编辑:程序博客网 时间:2024/05/19 23:15
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();
    }
原创粉丝点击