Use of a transaction : Transactions « Database ADO.net « C# / C Sharp






Use of a transaction

using System;
using System.Data;
using System.Data.SqlClient;

class ExecuteTransaction
{
  public static void Main()
  {
    SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");

    mySqlConnection.Open();

    SqlTransaction mySqlTransaction = mySqlConnection.BeginTransaction();

    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

    mySqlCommand.Transaction = mySqlTransaction;

    mySqlCommand.CommandText =
      "INSERT INTO Employee (" +
      "  ID, FirstName" +
      ") VALUES (" +
      "  10, 'Jason'" +
      ")";

    Console.WriteLine("Running first INSERT statement");
    mySqlCommand.ExecuteNonQuery();

    mySqlCommand.CommandText =
      "INSERT INTO Employee (" +
      "  ID, FirstName" +
      ") VALUES (" +
      "  11, 'Jason'" +
      ")";

    Console.WriteLine("Running second INSERT statement");
    mySqlCommand.ExecuteNonQuery();

    Console.WriteLine("Committing transaction");
    mySqlTransaction.Commit();

    mySqlConnection.Close();
  }
}



           
       








Related examples in the same category

1.Set a savepoint in a transaction
2.illustrates the use of transactions
3.Transaction roll back and commit
4.Commit two delete sql command
5.Update Data Using Transactions