Question

gridview 编辑事件无法更新数据

进入编辑后，点击更新，发现还是原来的数据，下面是我的代码，请高手看看那儿出错了

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();
}

Answer 1

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
this.GridView1.EditIndex = e.NewEditIndex;
getData();
}

把这个getdata（）去掉。

Answer 2

代码似没错的.你调试一下看看更新有没有问题.看看具体变量的值的变化.

Answer 3

...