private void changeButton_Click(object sender, EventArgs e) { DataSet ds = pD.getPassword(); string old = ds.Tables[0].Rows[0]["password"].ToString(); if (oldBox.Text == old) { if (newBox.Text == confirmBox.Text) { p = new passwordDTO(newBox.Text); pD.updatePassword(p); oldBox.Text = ""; newBox.Text = ""; confirmBox.Text = ""; MessageBox.Show("Password Changed !"); } else { MessageBox.Show("Passwords not matched !"); } } else { MessageBox.Show("Incorrect password !"); } }
public void updatePassword(passwordDTO p) { s.sqlConnection.Open(); string query = "update passwords set password = '******' where userName = '******'"; s.sqlCommand = new SqlCommand(query, s.sqlConnection); s.sqlCommand.ExecuteNonQuery(); s.sqlConnection.Close(); }