VB .net Update does not seem to commit
52341Oct 10 2003 — edited Oct 13 2003I am trying to do a ExecuteNonQuery but I do not seem to see any changes in the database (Oracle 8i). The code is placed in a try/catch and there does not seem to be an exception. What do I need to do to commit the update?
...
sql_string = "update testreqstate set reqstateid = 1 where reqstateid = 2"
Dim cmd As OracleCommand = conn.CreateCommand
cmd.CommandText = sql_string
cmd.ExecuteNonQuery()
...