gridview无法更新，大家帮忙看看

[pegnjw]

能实现编辑，但点击更新后内容不变，我的代码：
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridView1.DataSource = SqlDataSource2;
GridView1.DataKeyNames = new string[] { "ID" };
GridView1.DataBind();
string str2 = GridView1.DataKeys[e.RowIndex].Values[0].ToString();//获取gridview的主键

string sqlStr = string.Format("update WEBGIS08 set NAME='{0}',SEX='{1}',TELEPHONE='{2}',WORKID='{3}',BIRTHDAY='{4}',QQ='{5}' where ID='{6}'",
((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() ,
((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim(),
((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim(),
((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim(),
((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim(),
((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim(),
str2);

OracleCommand cmd=new OracleCommand (sqlStr ,DBcon .myConn );
DBcon .myConn .Open ();
int rowCount= cmd .ExecuteNonQuery();
DBcon .myConn .Close ();
if (rowCount >0)
{
GridView1 .EditIndex =-1;
string sql1=string .Format ("select * from WEBGIS08");
refreshDgv (sql1 ,true );
}

}
实现编辑的代码：
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;//单击一次“编辑”按钮
string sql = string.Format("select * from WEBGIS08");
refreshDgv(sql, true);
}

[pegnjw]

我已经知道是sqlStr没有执行，但不知道为什么没执行

[pegnjw]

断电查询后，发现可以update语句中无法读取编辑后的gridview里的内容