SqlTransaction::Rollback Method (String^)
Rolls back a transaction from a pending state, and specifies the transaction or savepoint name.
Assembly: System.Data (in System.Data.dll)
Parameters
- transactionName
-
Type:
System::String^
The name of the transaction to roll back, or the savepoint to which to roll back.
| Exception | Condition |
|---|---|
| ArgumentException | No transaction name was specified. |
| InvalidOperationException | The transaction has already been committed or rolled back. -or- The connection is broken. |
The Rollback method is equivalent to the Transact-SQL ROLLBACK TRANSACTION statement. For more information, see "Explicit Transactions" and "Transaction Savepoints" in SQL Server Books Online.
The transaction can only be rolled back from a pending state (after BeginTransaction has been called, but before Commit is called). The transaction is rolled back if it is disposed before Commit or Rollback is called.
 Note |
|---|
Try/Catch exception handling should always be used when rolling back a transaction. A 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 BeginTransaction, Commit, 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