Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. SqlCommand sqlCommand = new SqlCommand("Select * from
  2. POSbyahmar.dbo.Accounts where Name = '" + UserName.Text + "' ",
  3. sqlConnection);
  4. SqlDataReader dataReader;
  5. dataReader = sqlCommand.ExecuteReader();
  6. while(dataReader.Read())
  7. {
  8. string usernamefrmdatabase =
  9. dataReader["Name"].ToString();
  10. string passwordfromdatabase =
  11. dataReader["Password"].ToString();
  12. string uusernamefromuser = UserName.Text;
  13. string passwordfromuser = PasswordTextBox.Text;
  14.  
  15.  
  16. if (String.Equals(usernamefrmdatabase,
  17. uusernamefromuser))
  18. {
  19.  
  20. MessageBox.Show("reader working");
  21. MessageBox.Show(usernamefrmdatabase);
  22. MessageBox.Show(passwordfromdatabase);
  23.  
  24.  
  25.  
  26. }
  27.  
  28. //MessageBox.Show(usernamefrmdatabase);
  29. // MessageBox.Show(passwordfromdatabase);
  30.  
  31.  
  32.  
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement