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(); }