datalist分页实例

最新推荐文章于 2024-11-01 15:32:36 发布

weixin_30475039

最新推荐文章于 2024-11-01 15:32:36 发布

阅读量49

点赞数

文章标签：操作系统

原文链接：http://www.cnblogs.com/dearamy/archive/2010/04/18/1714998.html

版权

html代码：

datalist分页是通过PagedDataSource类来实现的。该类封装数据绑定控件与分页相关的属性，以允许该控件执行分页操作。

后台代码

using System.data.sqlclient;

DB db = new DB();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }
    public void bind()
    {

        int currentpage = Convert.ToInt32(labnowpage.Text);
        PagedDataSource ps = new PagedDataSource();//生成pageddatasource的实例
        string selstr = "select * from tb_CounterInfo";
        string slqcon = ConfigurationManager.AppSettings["getcon"].ToString();
        SqlConnection con = new SqlConnection(slqcon);
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter(selstr,con);
        DataSet ds=new DataSet();
        da.Fill(ds, "CounterInfo");
        ps.DataSource = ds.Tables["CounterInfo"].DefaultView;
        ps.AllowPaging = true;
        ps.PageSize = 4;
        ps.CurrentPageIndex = currentpage - 1;
        lkbtnfirst.Enabled = true;
        lkbtnfront.Enabled = true;
        lkbtnnext.Enabled = true;
        lkbtnlast.Enabled = true;
        if (currentpage == 1)
        {
            lkbtnlast.Enabled = false;
            lkbtnfront.Enabled = false;
        }
        if (currentpage == ps.PageCount)
        {
            lkbtnnext.Enabled = false;
            lkbtnlast.Enabled = false;
        }
        this.labcount.Text = Convert.ToString(ps.PageCount);
        this.DataList1.DataSource = ps;
        this.DataList1.DataKeyField = "ID";
        this.DataList1.DataBind();
    }
    protected void lkbtnfirst_Click(object sender, EventArgs e)
    {
        this.labnowpage.Text = "1";

        bind();
    }
    protected void lkbtnfront_Click(object sender, EventArgs e)
    {
        this.labnowpage.Text = Convert.ToString(Convert.ToInt32(this.labnowpage.Text) - 1);
        bind();
    }
    protected void lkbtnnext_Click(object sender, EventArgs e)
    {
        this.labnowpage.Text = Convert.ToString(Convert.ToInt32(this.labnowpage.Text) + 1);
        bind();
    }
    protected void lkbtnlast_Click(object sender, EventArgs e)
    {
        this.labnowpage.Text = this.labcount.Text;
        bind();
    }