SqlTransaction::Commit Method ()
Commits the database transaction.
Assembly: System.Data (in System.Data.dll)
| Exception | Condition |
|---|---|
| Exception | An error occurred while trying to commit the transaction. |
| InvalidOperationException | The transaction has already been committed or rolled back. -or- The connection is broken. |
The Commit method is equivalent to the Transact-SQL COMMIT TRANSACTION statement. You cannot roll back a transaction once it has been committed, because all modifications have become a permanent part of the database. For more information, see SQL Server Books Online.
 Note |
|---|
Try/Catch exception handling should always be used when committing or rolling back a SqlTransaction. Both Commit and Rollback generates an InvalidOperationException if the connection is terminated or if the transaction has already been rolled back on the server. |
For more information on SQL Server transactions, see "Explicit Transactions" and "Coding Efficient Transactions" in SQL Server Books Online.
The following example creates a SqlConnection and a SqlTransaction. It also demonstrates how to use the Commit, BeginTransaction, and Rollback methods. The transaction is rolled back on any error. Try/Catch error handling is used to handle any errors when attempting to commit or roll back the transaction.
Available since 1.1