I am using the following code to try and update a database entry, the UPDATE statement works when i am not using parameters but when i am using them it seems to do absolutely nothing. No error and no update either.
PHP Code:
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue"
dbCommand.CommandText = sqlString
dbCommand.Parameters.AddWithValue("@value1", txtOne.Text)
dbCommand.Parameters.AddWithValue("@field2 ", txtTwo.Text)
dbCommand.Parameters.AddWithValue("@field3 ", txtThree.Text)
dbCommand.Parameters.AddWithValue("@currentValue", lstListBox.SelectedValue)
dbCommand.ExecuteNonQuery()
Can anyone tell me why this isnt working?