public void ExecuteTransaction(string connectionString)` { using (OleDbConnection connection = new OleDbConnection(connectionString)) { OleDbCommand command = new OleDbCommand(); OleDbTransaction trancation = null; command.Connection = connection; try { connection.Open(); trancation = connection.BeginTransaction(IsolationLevel.ReadCommitted); command.Connection = connection; command.CommandText = ""; command.ExecuteNonQuery(); command.CommandText = ""; command.ExecuteNonQuery(); trancation.Commit(); Console.WriteLine("Commited"); } catch (Exception ex) { Console.WriteLine(ex.Message); try { trancation.Rollback(); } catch { Console.WriteLine(ex.InnerException); } } } }
In this code we will see Oledb Multiple Query with commit and if fails it rolls back