using System.Data.SqlClient;
SqlConnection myconn = new SqlConnection("server=LAPTOP-0LGEPDGC\\SQLEXPRESS;Trusted_Connection=SSPI;database=User");
SqlCommand mycomm;
SqlDataReader mydr;
private void btnConfirmUte_Click(object sender, EventArgs e)
{
try
{
if (myconn.State == ConnectionState.Closed)
{
myconn.Open();
}
mycomm = new SqlCommand("select * from userTable where userName = '" + txtUtName.Text.Trim() + "'", myconn);
mydr = mycomm.ExecuteReader();
if (txtUtName.Text == "")
{
MessageBox.Show("用户名不可为空!");
txtUtName.Focus();
return;
}
else
{
if (mydr.Read())
{
if (txtNewPwd.Text == "")
{
MessageBox.Show("新密码不可为空!");
txtNewPwd.Focus();
//return;
}
else if (txtNewPwdsure.Text == "")
{
MessageBox.Show("确认密码不可为空!");
txtNewPwdsure.Focus();
//return;
}
else if (txtNewPwd.Text != txtNewPwdsure.Text)
{
MessageBox.Show("两次密码输入不同,请重新输入");
txtNewPwd.Clear();
txtNewPwdsure.Clear();
txtNewPwd.Focus();
//return;
}
else
{
mydr.Close();
mycomm = new SqlCommand("update userTable set userPwd = '" + txtNewPwd.Text.Trim() + "'where userName = '" + txtUtName.Text.Trim() + "'", myconn);
int num = mycomm.ExecuteNonQuery();
if(num > 0)
{
MessageBox.Show("密码修改成功!");
}
else
{
MessageBox.Show("修改失败!");
}
//this.Hide();
}
}
else
{
MessageBox.Show("没有该用户!");
txtUtName.Focus();
}
}
myconn.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void btnBLogin_Click(object sender, EventArgs e)
{
this.Hide();
Login login = new Login();
login.ShowDialog();
}