直接说问题,在一个更新gridview里的数据时 ,点击 编辑,输入数据库后点更细,虽提示更新成功,但是数据库里的数据没有改变 ,求高手,求指点,下面是代码
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string missioncode = ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString().Trim();
missioncode += "4";
string illcode = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString().Trim();
string missionname = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString().Trim();
string missioncontent = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
Response.Write(GridView1.DataKeys[e.RowIndex].Value.ToString());
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());
SqlCommand comm = new SqlCommand("update MISSION_DICT set MISSION_CODE='" + missioncode + "' , ILL_CODE='" + illcode + "' , MISSION_NAME='" + missionname + "' , MISSION_CONTENT='" + missioncontent + "' where MISSION_CODE='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'", conn);
conn.Open();
//try
//{
int i = Convert.ToInt32(comm.ExecuteNonQuery());
if (i > 0)
{
Response.Write("<script language=javascript>alert('修改成功!');location='WebForm1.aspx';</script>");
}
else
{
Response.Write("<script language=javascript>alert('修改失败!')</script>");
}
GridView1.EditIndex = -1;
//}
//catch (Exception erro)
//{
// Response.Write("错误信息:" + erro.Message);
//}
//finally
//{
// conn.Close();
//}
}