SqlConnection conn = new SqlConnection("连接数据库");
conn.Open();
string yonghuming = TextBox1.Text.ToString();
string sql = "update 用户表 set 姓名 = '" + TextBox2.Text.ToString() + "', 性别 = '" + TextBox4.Text.ToString() + "', 手机号 = '" + TextBox7.Text.ToString() + "' where 用户名 = '" + yonghuming + "'";
SqlCommand com = new SqlCommand(sql, conn);
com.ExecuteNonQuery();
int count = com.ExecuteNonQuery();
if (count > 0)
{
Response.Write("<script language = javascript>alert('亲,数据更新成功!');</script>");
}
else
{
Response.Write("<script language = javascript>alert('亲,数据更新失败!');</script>");
}
conn.Close();
Response.Redirect("http://localhost:42680/de.aspx", false);