Guest User

Untitled

a guest
Apr 16th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. Dim objConnection As New OleDb.OleDbConnection(
  2.  
  3. "Provider=Microsoft.ACE.OLEDB.12.0;" &
  4.  
  5. "Data Source=Login.accdb")
  6.  
  7. Dim objDA As _
  8.  
  9. New OleDb.OleDbDataAdapter("SELECT * FROM User", objConnection)
  10.  
  11. Dim objCB As New OleDb.OleDbCommandBuilder(objDA)
  12.  
  13. Dim objDS As New DataSet()
  14.  
  15. Public Username, Password As String
  16.  
  17. Dim UserFound As Boolean
  18.  
  19. Private Sub frmLogin_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  20. Retrieve()
  21. End Sub
  22.  
  23. Private Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click
  24. Username = txtUser.Text
  25. Password = txtPassword.Text
  26.  
  27. For i As Integer = 1 To (objDS.Tables("User").Rows.Count)
  28.  
  29. If CStr(objDS.Tables("User").Rows(i - 1).Item("Username")) =
  30. Username And
  31. CStr(objDS.Tables("User").Rows(i - 1).Item("Password")) = Password Then
  32. UserFound = True
  33. Me.Hide()
  34. MessageBox.Show("Welcome to the System!")
  35. frmStudents.Show()
  36. Exit For
  37. End If
  38. txtUser.Text = String.Empty
  39. txtPassword.Text = String.Empty
  40. Next
  41. If UserFound = False Then
  42. MessageBox.Show("Access Denied")
  43. End If
  44. End Sub
  45.  
  46. Private Sub Retrieve()
  47. objDS.Clear()
  48.  
  49.  
  50. objDA.FillSchema(objDS, SchemaType.Source, "User")
  51. objDA.Fill(objDS, "User")
  52.  
  53. End Sub
Add Comment
Please, Sign In to add comment