if (textBox1.Text == ""||textBox2.Text == ""||textBox3.Text == "")
{
MessageBoxButtons.YesNo, MessageBoxIcon.Question) ==
DialogResult.Yes)
{
this.Close();
}
}
else if(textBox2.Text!=textBox3.Text)
{
MessageBoxButtons.YesNo, MessageBoxIcon.Question) ==
DialogResult.Yes)
{
this.Close();
}
}
else if (textBox1.Text != "")
{
string constr = "integrated security=SSPI;data source=.;persist security info=False;initial catalog=anne";
string sq1 = "select 密码 from 密码表 where 用户名='admin'";
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sq1, sqlConnection1);
DataSet dt1 = new DataSet();
sqlDataAdapter1.Fill(dt1, "密码表");
string sq2= textBox1.Text;
string sq3 = (string)dt1.Tables["密码表"].Rows[0]["密码"];
if (sq2.Equals(sq3.Trim()) && textBox2.Text == textBox3.Text)
{
string constr1 = "integrated security=SSPI;data source=.;persist security info=False;initial catalog=anne";
string sq4 = "update 密码表 set 密码='" + textBox2.Text + "' where 密码='" + textBox1.Text + "'";
SqlConnection sqlConnection = new SqlConnection(constr1);
sqlConnection.Open();
SqlCommand cd = new SqlCommand(sq4, sqlConnection);
SqlDataReader sr = cd.ExecuteReader();
MessageBox.Show(" 密码已修改成功 ", "提 醒");
}
}
发布评论