进入编辑后,点击更新,发现还是原来的数据,下面是我的代码,请高手看看那儿出错了protected void Page_Load(object sender, EventArgs e)
    {
        getData();
    }
    public void getData()
    {
        SqlConnection cn = new SqlConnection("server=40560905DF484C2;database=db_Certificate;user=sa;password=;");
        SqlCommand cmd = new SqlCommand("select * from dbo.Person", cn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "dbo.person");
        this.GridView1.DataSource = ds.Tables[0].DefaultView;
        this.DataBind();
    }    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        getData();
    }
        
    
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        getData();
        
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex = e.NewEditIndex;
        getData();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        
        string ID = this.GridView1.DataKeys[e.RowIndex][0].ToString();
        string Personname = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text .ToString();
        string Personage = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString();
        string Personsex= ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString();
        string Personposition=((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString();
        updateperson(ID, Personname, Personage, Personsex, Personposition);
        this.GridView1.EditIndex = -1;
        getData();
    }
    public void updateperson(string ID, string Personname, string Personage, string Personsex, string Personposition)
    {
        SqlConnection cn = new SqlConnection("server=40560905DF484C2;database=db_Certificate;user=sa;password=");
        SqlCommand cmd = new SqlCommand("update dbo.Person set Personname ='" + Personname + "',Personage ='" + Personage + "',Personsex ='" + Personsex + "',Personposition ='" + Personposition + "'where ID ='"+ID+"'", cn);
        cn.Open();
        cmd.ExecuteNonQuery();
        cn.Close();
    }