gridview分页方法

//分页索引变化时
    protected void gv_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gv.PageIndex = e.NewPageIndex;
        gv.DataSource = selectAllTitle();
        gv.DataBind();
    }
   // 单击编辑时发生
    protected void gv_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gv.EditIndex = e.NewEditIndex;
        gv.DataSource = selectAllTitle();
        gv.DataBind();
    }
    //更新数据
    protected void gv_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        SqlConnection conn = new SqlConnection("server=.;database=teacherTask;uid=sa;pwd=123456");
        conn.Open();
        string id = ((TextBox)(gv.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString();
        string title = ((TextBox)(gv.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
        string sql = "update test set title='"+title+"' where id='"+id+"'"; 
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.ExecuteNonQuery();
        conn.Close();
        gv.EditIndex = -1;
        gv.DataSource = selectAllTitle();
        gv.DataBind();
    }
   // 取消更新数据
    protected void gv_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gv.EditIndex = -1;
        gv.DataSource = selectAllTitle();
        gv.DataBind();
    }
  // 删除数据
    protected void gv_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

        int id = int.Parse(gv.DataKeys[e.RowIndex].Values[0].ToString());
        SqlConnection conn = new SqlConnection("server=.;database=teacherTask;uid=sa;pwd=123456");
        SqlCommand cmd = new SqlCommand("delete from test where id="+id, conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
        gv.DataSource = selectAllTitle();
        gv.DataBind();
    }