Advertisement
Guest User

Untitled

a guest
Jul 6th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.60 KB | None | 0 0
  1. conn = New MySqlConnection
  2.         conn.ConnectionString = "server=SERVER.COM;Port=3306; user id=USERID; password=PASSWORD; database=DATABASE"
  3.         Try
  4.             conn.Open()
  5.             Dim sqlquery = "SELECT * From Users WHERE username='" & textbox1.text & "'"
  6.             Dim command As New MySqlCommand
  7.             Dim adapter As New MySqlDataAdapter
  8.             Dim data As MySqlDataReader
  9.             command.Connection = conn
  10.             command.CommandText = sqlquery
  11.             adapter.SelectCommand = command
  12.             data = command.ExecuteReader
  13. catch ex as exception
  14. msgbox(ex.message)
  15. end try
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement