login and update sql database using vb.net

aning diaz

13y1.5k

Dim conn As MySqlConnection

conn = New MySqlConnection()

conn.ConnectionString = "Server=localhost;User Id=root;Passsword=;Database=voting "

Try

conn.Open()

Catch myerror As MySqlException

MsgBox("error")

End Try

Dim myAdapter As New MySqlDataAdapter

Dim myCommand As New MySqlCommand()

myCommand.Connection = conn

myAdapter.SelectCommand = myCommand

If Textuser.Text = "" And Textpass.Text = "" Then

MsgBox("invalid")

ElseIf myCommand.CommandText = "SELECT * FROM tbl_elemvoters WHERE Username = '" + Textuser.Text + "' AND VoterID='" + Textpass.Text + "UPDATE Voted='" + "Yes"

Form2.Show()

Me.Hide()

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Pandey13y ago
hiii

what the issue you are facing here?
0
Jignesh Trivedi13y ago
hi,
are you facing any problem or getting any error?
your command text has syntext error; missing "AND"
myCommand.CommandText = "SELECT * FROM tbl_elemvoters WHERE Username = '" + Textuser.Text + "' AND VoterID='" + Textpass.Text + "' AND UPDATE Voted='" + "Yes'"
0