Gridview的分页问题

来源：互联网发布：地板防滑垫淘宝网编辑：程序博客网时间：2024/05/06 12:43

刚才我做实验时遇到了这样的一个问题：代码如下

        protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = db.creatconn();
        con.Open();
       SqlCommand cmd = new SqlCommand("SELECT [about], [link] FROM [ClassNews]", con);
        SqlDataReader sdr = cmd.ExecuteReader();
        this.GridView1.DataSource = sdr;
        this.GridView1.DataBind();

}

GridView1的AllowPaging和 PageSize属性分别设为Yes 和5，但是执行时点击分页数却出错了，提示如下：

GridView“GridView1”激发了未处理的事件“PageIndexChanging”。

在网上查了大半天，终于成功了，现将代码修改如下：

protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = db.creatconn();
        con.Open();
        //SqlCommand cmd = new SqlCommand("SELECT [about], [link] FROM [ClassNews]", con);
        //SqlDataReader sdr = cmd.ExecuteReader();
        //this.GridView1.DataSource = sdr;
        //this.GridView1.DataBind();
        SqlDataAdapter sda = new SqlDataAdapter("SELECT [about], [link] FROM [ClassNews]", con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "ClassNews");
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }

GridView1就能正常地分页了。