Use OleDbTransaction : OleDbTransaction « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. OleDbTransaction

Use OleDbTransaction

using System;
using System.Data;
using System.Data.OleDb;

public class Transact {    
 public static void Main () { 
   String connect = "Provider=Microsoft.JET.OLEDB.4.0;data source=.\\Employee.mdb";
   OleDbConnection con = new OleDbConnection(connect);
   con.Open();  
   Console.WriteLine("Made the connection to the database");
   OleDbCommand cmd = con.CreateCommand();

   OleDbTransaction trans = con.BeginTransaction();
   cmd.Transaction = trans;
   cmd.CommandText = "UPDATE Employee SET Salary = 1342 "
                        + "WHERE ID > 1";
   cmd.ExecuteNonQuery();

   cmd.CommandText = "SELECT First_name FROM Employee";
   OleDbDataReader reader = cmd.ExecuteReader();

   while(reader.Read()) 
     Console.WriteLine("{0}",
               reader.GetString(0));
   reader.Close();

   con.Close();
 }
}
           
       

Related examples in the same category

1.	Illustrates transaction processing
2.	OleDbTransaction rollback
3.	Committed insert