Guest User

Untitled

a guest
Feb 16th, 2019
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. 'Validation for admin:
  2. cmd = New OleDbCommand("SELECT * FROM tblSettings WHERE Admin_username=@Username AND Admin_password=@password;", conn)
  3. Try
  4. conn.Open()
  5. 'Add parameters:
  6. cmd.Parameters.AddWithValue("@username", txtUsername.Text)
  7. cmd.Parameters.AddWithValue("@password", txtPassword.Text)
  8. 'Reader in action:
  9. Using rd As OleDbDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
  10. If rd.Read Then
  11. If StrComp(txtPassword.Text, rd.GetValue(rd.GetOrdinal("Admin_password")), 0) = 0 Then
  12. cmd.ExecuteNonQuery()
  13. Me.Hide()
  14. frmLoginType.Hide()
  15. frmMain.MenuStrip1.Enabled = True
  16. Else
  17. ErrorProvider1.SetError(txtPassword, "Invalid password!")
  18. End If
  19. Else
  20. ErrorProvider1.SetError(txtUsername, "Invalid username!")
  21. ErrorProvider1.SetError(txtPassword, "Invalid password!")
  22. End If
  23. rd.Close()
  24. End Using
  25. 'Close connection:
  26. cmd.Dispose()
  27. conn.Close()
  28. Catch ex As Exception
  29. MsgBox(ex.Message, vbCritical, "Error")
  30. End Try
  31. End Try
Add Comment
Please, Sign In to add comment