private void button4_Click(object sender, EventArgs e) { xgmmb form = new xgmmb(); form.Show(); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == string.Empty) { MessageBox.Show(this, " 请输入用户名! ", "Phoenix Information:", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (textBox2.Text == string.Empty) { MessageBox.Show(this, " 请输入旧密码! ", "Phoenix Information:", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (textBox3.Text == string.Empty) { MessageBox.Show(this, " 请输入新密码! ", "Phoenix Information:", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (textBox4.Text == string.Empty) { MessageBox.Show(this, " 请确认新密码! ", "Phoenix Information:", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (textBox3.Text != textBox4.Text) { MessageBox.Show("两次输入的密码不一致!"); return; } string username = textBox1.Text.Trim(); string password = textBox2.Text.Trim(); string newpassword = textBox3.Text.Trim(); string str = "Data Source=DESKTOP-H6GDTOQ\\SQLEXPRESS;Initial Catalog=slfsql;Integrated Security=True"; SqlConnection con = new SqlConnection(str); con.Open(); string sql = string.Format("select count(*) from [yhdlb] where username='******' and password='******'", username, password); SqlCommand cmd = new SqlCommand(sql, con); int num = (int)cmd.ExecuteScalar(); if (num > 0) { string sqll = "UPDATE yhdlb SET password='******'where username='******'and password='******'"; SqlCommand cmdd = new SqlCommand(sqll, con); cmdd.CommandText = sqll; cmdd.ExecuteNonQuery(); con.Close(); MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("修改失败,请确保用户名与密码正确!"); xgmmb form = new xgmmb(); form.Show(); this.Hide(); } con.Close(); }