I have been making an application for members which they can connect to upload files and check news.
But when i got the code all set up and press run entered the username and password i get a nasty error at mydata = command.ExecuteReader saying
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= From Users WHERE Username='ADMIN'And Password='password' at line 1"
Please help as i want this application finished :)
Public Class fairwayloginaccount
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection
MySqlConnection.ConnectionString = "server=aerolitegaming.co.uk;Port=3306; user id=hidden; password=hidden; database=lukea_fairways"
Dim Myadapter As New MySqlDataAdapter
Dim sqlquary = "SELECT = From Users WHERE Username='" & UsernameTextBox.Text & "'And Password='" & PasswordTextBox.Text & "';"
Dim command As New MySqlCommand
command.Connection = MySqlConnection
command.CommandText = sqlquary
Myadapter.SelectCommand = command
View Complete Post