OleDbConnection myConn
=
new
OleDbConnection(db.ConnStr);
myConn.Open();
OleDbTransaction myTran = myConn.BeginTransaction();
OleDbCommand myComm = new OleDbCommand();
myComm.Connection = myConn;
myComm.Transaction = myTran;
try
... {
myComm.CommandText = "insert into table1(id,name) values('1','admin')";
myComm.ExecuteNonQuery();
myTran.Commit();
}
catch (Exception e)
... {
myTran.Rollback();
MessageBox.Show(e.Tostring());
}
finally
... {
myConn.Close();
myComm.Dispose();
}
myConn.Open();
OleDbTransaction myTran = myConn.BeginTransaction();
OleDbCommand myComm = new OleDbCommand();
myComm.Connection = myConn;
myComm.Transaction = myTran;
try
... {
myComm.CommandText = "insert into table1(id,name) values('1','admin')";
myComm.ExecuteNonQuery();
myTran.Commit();
}
catch (Exception e)
... {
myTran.Rollback();
MessageBox.Show(e.Tostring());
}
finally
... {
myConn.Close();
myComm.Dispose();
}