C#sql UPDATE 更新(某个数据)(更新密码-从用户名)
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=*****;database=sanjiang");
conn.Open();
string yonghuming = TextBox1.Text.ToString();
string sql = "UPDATE list SET 密码='" + TextBox2.Text + "' where 用户名 = '" + Label1.Text + "'";
SqlCommand com = new SqlCommand(sql, conn);
com.ExecuteNonQuery();
int count = com.ExecuteNonQuery();
if (count > 0)
{
Response.Write("
");
}
else
{
Response.Write("
");
}
conn.Close();