c#为什么这段代码密码修改成功但数据库没更新呢。。求助大虾们了。。。
string strQuery = "SELECT COUNT (*) FROM Admin Where ID='"+ID +"' and Pwd='" + tbpwd.Text + "' and username ='" + this.tbname.Text + "'";
SqlCommand cmd = new SqlCommand(strQuery, conn);
if ((int)cmd.ExecuteScalar() > 0)//修改密码之前先查询原始密码是否正确
{
if (tbnewpwd.Text == tbsure.Text)//两次密码是否相等
{
cmd = new SqlCommand("update Admin set username ='" + this.tbname.Text + "',pwd ='" + this.tbpwd.Text + "' where ID='" + this.txtid.Text + "' ", conn);
int count =Convert.ToInt32( cmd.ExecuteNonQuery());
if (count > 0)
{
MessageBox.Show("密码修改成功");
}
else
{
MessageBox.Show("密码修改失败");
return;
}
}
else
{
MessageBox.Show("两次密码输入不一致!");
return;
}
conn.Close();
}
}