Guest User

Untitled

a guest
Jan 7th, 2019
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. Private Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click
  2. Call DatabaseConnection()
  3. CMD = New SqlCommand("SELECT * FROM UserAplikasi WHERE username = '" + txtUsername.Text + "' AND password = '" + txtUsername.Text + "'", CONN)
  4. RD = CMD.ExecuteReader
  5. If RD.HasRows = True Then
  6. ElseIf RD.Item("HakAkses").ToString = "administrator" Then
  7. Me.Hide()
  8. FormMenuUtama.MenuStripFormUtama.Items("HOME").Enabled = True
  9. FormMenuUtama.MenuStripFormUtama.Items("ORDERPLAN").Enabled = True
  10. FormMenuUtama.MenuStripFormUtama.Items("FINANCE").Enabled = True
  11. FormMenuUtama.MenuStripFormUtama.Items("BILLING").Enabled = True
  12. RD.Close()
  13. ElseIf RD.Item("HakAkses").ToString = "orderplan" Then
  14. Me.Hide()
  15. FormMenuUtama.MenuStripFormUtama.Items("HOME").Enabled = True
  16. FormMenuUtama.MenuStripFormUtama.Items("ORDERPLAN").Enabled = True
  17. FormMenuUtama.MenuStripFormUtama.Items("FINANCE").Enabled = False
  18. FormMenuUtama.MenuStripFormUtama.Items("BILLING").Enabled = False
  19. RD.Close()
  20. ElseIf MsgBox("Username atau Password yang anda masukan salah!") Then
  21. CONN.Close()
  22. End If
Add Comment
Please, Sign In to add comment