Transactions : Transaction « Database ADO.net « Visual C++ .NET

Transactions
 
#include "stdafx.h"
using namespace System;
using namespace System::Data;
using namespace System::Data::SqlClient;
using namespace System::Configuration;

void main(){
    String ^Name = "Doors";

    SqlConnection  ^connection = gcnew SqlConnection();
    SqlTransaction ^transaction;

    connection->ConnectionString = "SQLConnection";

    try{
       connection->Open();
       SqlCommand ^cmd = gcnew SqlCommand();

       transaction = connection->BeginTransaction(IsolationLevel::Serializable, "AuthorTransaction");

       cmd->Connection  = connection;
       cmd->Transaction = transaction;

       cmd->CommandType = CommandType::StoredProcedure;
       cmd->CommandText = "InsertAuthor";

       cmd->Parameters->Add(gcnew SqlParameter("@LastName", SqlDbType::Char,32));
       cmd->Parameters->Add(gcnew SqlParameter("@FirstName",SqlDbType::Char,32));

       cmd->Parameters["@LastName"]->Value  = "Dope";
       cmd->Parameters["@FirstName"]->Value = "John";

       int affected = cmd->ExecuteNonQuery();
       if (affected <= 0)
           throw gcnew Exception("Insert Failed");
       Console::WriteLine("Insert - {0} rows are affected", affected);

       cmd->CommandType = CommandType::Text;
       cmd->CommandText = "UPDATE Authors SET LastName = 'Doe' WHERE LastName = 'Dope'";

       affected = cmd->ExecuteNonQuery();
       if (affected <= 0)
           throw gcnew Exception("Insert Failed");
       Console::WriteLine("Update - {0} rows are affected", affected);

       cmd->CommandType = CommandType::Text;
       cmd->CommandText = "DELETE FROM Authors WHERE LastName = 'Does'";

       affected = cmd->ExecuteNonQuery();
       if (affected <= 0)
           throw gcnew Exception("Insert Failed");
       Console::WriteLine("Delete - {0} rows are affected", affected);

       transaction->Commit();
    }
    catch (Exception ^e)
    {
        transaction->Rollback("AuthorTransaction");
        Console::WriteLine("Transaction Not completed");
        Console::WriteLine("SQL error occurred: {0}", e->Message);
    }
    finally
    {
        connection->Close();
    }
}
Related examples in the same category

Using Transactions