oracle 怎么提交更新,OracleCommand更新不提交更改

谢谢大家指点我的方向。这是最终的工作代码。诀窍是使用oracletransaction,下面的代码非常有用。接下来使用参数。可以找到更多信息

here

Using dbConnection As New OracleConnection(OracleConnectionString)

'Open the connection

dbConnection.Open()

Dim dbCommand As OracleCommand = dbConnection.CreateCommand()

Dim dbTransaction As OracleTransaction

'Start a local transaction

dbTransaction = dbConnection.BeginTransaction(IsolationLevel.ReadCommitted)

'Assign transaction object for a pending local transaction

dbCommand.Transaction = dbTransaction

Try

dbCommand.CommandType = CommandType.Text

dbCommand.CommandText = "UPDATE XXF_ASN_HEADERS SET BILL_OF_LADING_NUMBER ='" + BillOfLadingNumber + "', TRAILER_NUMBER ='" + TrailerNumber + "', CARRIER_CODE ='" + CarrierCode + "', TRANSPORTATION_METHOD ='" + TransportationMethod + "' WHERE HEADERID ='" + Request.QueryString("HeaderId") + "'"

dbCommand.ExecuteScalar()

dbTransaction.Commit()

Response.Redirect("default.aspx")

Catch ex As OracleException

'Rollback the transaction

dbTransaction.Rollback()

'display error details

lblUpdateQuery.Text = dbCommand.CommandText

lblDebug.Text = ex.Message.ToString

End Try

End Using