I've got a database called Account, and a Table called Accounts. I have 4 columns in this table. Id(Key column), UserName, Password and Adminpower.
What I am trying to do is to make a button change a value in that table. What I do not know is how to make the program know which row i want to change the value in.
Private Sub btnAdmin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdmin.Click Dim cmd As SqlCommand Dim reader As SqlDataReader con = New SqlConnection(_connectionString) cmd = con.CreateCommand() con.Open() cmd.CommandText = "ALTER Accounts ('Adminpower') VALUES('1')" reader = cmd.ExecuteReader() If Not reader.HasRows Then MessageBox.Show("Something is wrong.") End If End Sub
That's the code so far for the button. So what I want it to do is to change the Adminpower column from 0 to 1 when pressing that button. Yes I have already connected it to the database.
When I try to press the button I get an error saying that the table doesn't exist.
Any help is appreciated.