c#中的事务处理

 

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