hi !! my background in vb.net is not that good, but i need to make a voting system, user must be log in once and update his status into yes after voting, i have a table namely tbl_elemvoters it has a fields : voterid, username, password, name, grade, section and voted.
on the field voted, it contains 'no' , then after they login the field voted that contains no will updated to yes.
here is my code:
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()
update doesnt working, im confused ;'(.
thanks for the help