Advertisement
Guest User

Untitled

a guest
Oct 12th, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.   If (My.Settings.canLogin = False) Then
  2.             MsgBox("System is disabled!")
  3.  
  4.         Else
  5.             Dim myReader As MySql.Data.MySqlClient.MySqlDataReader
  6.             Dim constring, query As String
  7.             constring = "server=127.0.0.1;port=3306;username=root;password=hesoyam"
  8.             query = "select * from jlb.admin where User = '" + User1.Text + "' and Password = '" + Pass1.Text + "';"
  9.             Dim conDatabase As New MySql.Data.MySqlClient.MySqlConnection(constring)
  10.             Dim cmdDatabase As New MySql.Data.MySqlClient.MySqlCommand(query, conDatabase)
  11.             Dim count As Integer
  12.  
  13.             Try
  14.                 conDatabase.Open()
  15.                 myReader = cmdDatabase.ExecuteReader
  16.                 While (myReader.Read)
  17.                     count = count + 1
  18.  
  19.  
  20.                 End While
  21.                 If (count = 1) Then
  22.                     OptionsMenu.Show()
  23.                     Me.Hide()
  24.                 Else
  25.                     MessageBox.Show("Username or Password is incorrect")
  26.                     If (My.Settings.Tries = 2) Then
  27.                         User1.Enabled = False
  28.                         Pass1.Enabled = False
  29.                         login1.Enabled = False
  30.                         My.Settings.canLogin = False
  31.                         My.Settings.time = 120000
  32.                         My.Settings.Save()
  33.                         Timer1.Start()
  34.                     Else
  35.                         My.Settings.Tries = My.Settings.Tries + 1
  36.                         My.Settings.Save()
  37.  
  38.                     End If
  39.  
  40.                 End If
  41.  
  42.  
  43.                     conDatabase.Close()
  44.             Catch ex As Exception
  45.                 MsgBox(ex.Message)
  46.             End Try
  47.         End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement