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