SqlConnection.RollbackTransaction Method

asp.net.ph

System.Data.SqlClient Namespace SqlConnection Class

Rolls back a database transaction from a pending state.

1. Rolls back a transaction from being applied to the database.

[ VB ] Overloads Overrides Public Sub RollbackTransaction ( )

[ C# ] public override void RollbackTransaction ( );

[ C++ ] public: void RollbackTransaction ( );

[ JScript ] public override function RollbackTransaction ( );

2. Rolls back a database transaction with the transaction name.

[ VB ] Overloads Public Sub RollbackTransaction ( String )

[ C# ] void RollbackTransaction ( string );

[ C++ ] public: void RollbackTransaction ( String* );

[ JScript ] public function RollbackTransaction ( String );

The following example initializes an SqlConnection, opens it, begins a transaction, rollsback the transaction, then closes the connection. To accomplish this, the method is passed an SQL connection string to use to connect to the data source.

NOTE: This example shows how to use one of the overloaded versions of RollbackTransaction. For other examples that may be available, see the individual overload topics.

void RunSqlTransaction ( string strConn ) {
   SqlConnection myConn = new SqlConnection ( strConn );
   myConn.Open ( );
   myConn.BeginTransaction ( "SampleTransaction" );
   myConn.RollbackTransaction ( "SampleTransaction" );
   myConn.Close ( );
}

SqlConnection Members

Friday, January 10, 2025

SqlConnection.RollbackTransaction Method

Overload List

Example

See Also