Guest User

Untitled

a guest
May 28th, 2018
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. if (txtNewPassword.Text == txtConfirmPassword.Text)
  2. {
  3. mSQL = "SELECT * FROM User WHERE userName = '" + txtUserName.Text + "' AND password = '" + txtPassword.Text + "'";
  4. mDT_Save = mDBHelper.GetTable(mSQL);
  5. if (mDT_Save.Rows.Count > 0)
  6. {
  7. for (int i = 0; i < mDT_Save.Rows.Count; i++)
  8. {
  9. mSQL = "UPDATE TableName SET password = '" + txtConfirmPassword.Text + "' WHERE user_name = '" + Convert.ToString(mDT_Save.Rows[i]["userName"]) + "'";
  10. mDBHelper.ExecuteSQLNonQuery(mSQL);
  11. }
  12. MessageBox.Show("Password Changed Successfully");
  13. txtPassword.Text = txtConfirmPassword.Text;
  14. return;
  15. }
  16. else
  17. {
  18. MessageBox.Show("User Not Found");
  19. return;
  20. }
  21. }
Add Comment
Please, Sign In to add comment