//修改密码 private void button_add_Click(object sender, EventArgs e) { if (CValidateTools.isNull(textBox_oldPwd.Text)) { CValidateTools.showError("请输入旧密码"); return; } if (CValidateTools.isNull(textBox_new1.Text)) { CValidateTools.showError("请输入新密码"); return; } if (textBox_new1.Text != textBox_new2.Text) { CValidateTools.showError("二次密码输入不一致"); return; } //查询此用户的旧密码是否正确 string str = "select * from userInfo where AdmName = '#username' and AdmPwd = '#pwd' "; str = str.Replace("#username", m_usname); str = str.Replace("#pwd", textBox_oldPwd.Text); ADOHelper db = new ADOHelper(); if (!db.ExecuteRead(str).HasRows) { CValidateTools.showError("旧密码不正确,无法修改新密码"); return; } //替换新密码 string strUpdate = "update userInfo set AdmPwd = '#pwd' where admName = '#admName' "; strUpdate = strUpdate.Replace("#admName", m_usname).Replace("#pwd", textBox_new1.Text); bool result = false; try { ADOHelper db1 = new ADOHelper(); result = db1.ExecuteUpdate(strUpdate); } catch (Exception ex) { CValidateTools.showError(ex.Message); return; } if (result) { CValidateTools.showOK("密码重置成功!"); } }