Advertisement
Guest User

Untitled

a guest
Jun 6th, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. if (!txtUsername.Equals(null) && !txtPassword.Equals(null))
  2. {
  3. string constring = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + System.Environment.CurrentDirectory + "../../../res/Coursework.accdb";
  4. string cmdText = "select Count(*) from tblUsers where username=? and password=?";
  5. using (OleDbConnection con = new OleDbConnection(constring))
  6. using (OleDbCommand cmd = new OleDbCommand(cmdText, con))
  7. {
  8. con.Open();
  9. cmd.Parameters.AddWithValue("@p1", txtUsername.Text);
  10. cmd.Parameters.AddWithValue("@p2", txtPassword.Text);
  11. int result = (int)cmd.ExecuteScalar();
  12.  
  13. if (result > 0)
  14. {
  15. if (true /* is admin*/) return; //show database edit form
  16. else return; //show database add form
  17. }
  18. else
  19. MessageBox.Show("Invalid Login, Please Re-Enter.");
  20. }
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement