試下下面的代碼:
string?yonghu?=?"";//用戶名string?oldPassword?=?textBox1.Text.Trim();//取原密碼框的內容
string?newPassword?=?textBox2.Text.Trim();//取新密碼框的內容
string?repeatPassword?=?textBox3.Text.Trim();//取重復密碼框的內容
string?strConn?=?"";//連接字符串
string?sql?=?"";
if?(newPassword?==?repeatPassword)
{
SqlConnection?conn?=?new?SqlConnection(strConn);
conn.Open();
sql?=?string.Format("select?count(*)?from?[user]?where?yonghu='{0}'?and?password='{1}'",yonghu?,oldPassword);
SqlCommand?cmd?=?new?SqlCommand(sql,conn);
if?((int)(cmd.ExecuteScalar())>0)
{
sql?=?string.Format("update?[user]?set?password='{0}'?where?yonghu='{1}'",newPassword,yonghu);
cmd?=?new?SqlCommand(sql,conn);
cmd.ExecuteNonQuery();
MessageBox.Show("密碼修改成功!");
}
else
{
MessageBox.Show("原密碼不正確!");
}
conn.Close();
}
else
{
MessageBox.Show("兩次密碼輸入不壹致!");
}