Csharp/C Sharp by API/System.Data.OleDb/OleDbTransaction
OleDbTransaction.Commit()
<source lang="csharp">
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.rumandText ="INSERT INTO Employee VALUES (12,"CD","wwe",10)"; cmd.ExecuteNonQuery(); trans.rumit();
cmd.rumandText = "SELECT First_name FROM Employee"; OleDbDataReader reader = cmd.ExecuteReader(); while(reader.Read()) Console.WriteLine("{0}", reader.GetString(0)); reader.Close();
con.Close(); }
}
</source>
OleDbTransaction.Rollback()
<source lang="csharp"> 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.rumandText ="INSERT INTO Employee VALUES (09,"qwe","ewq",123)"; cmd.ExecuteNonQuery(); cmd.rumandText = "SELECT First_name FROM Employee"; OleDbDataReader reader = cmd.ExecuteReader(); while(reader.Read()) Console.WriteLine("{0}", reader.GetString(0)); reader.Close(); trans.Rollback(); cmd.rumandText = "SELECT First_name FROM Employee"; reader = cmd.ExecuteReader(); Console.WriteLine("Rolled back insert and update -- table unchanged"); Console.WriteLine("First_name"); while(reader.Read()) Console.WriteLine("{0}", reader.GetString(0)); reader.Close();
con.Close(); }
}
</source>