c#实现sqlserver事务处理示例

privatestaticvoidExecuteSqlTransaction(stringconnectionString)
   {
       using(SqlConnectionconnection=newSqlConnection(connectionString))
       {
           connection.Open();
           SqlCommandcommand=connection.CreateCommand();
           SqlTransactiontransaction;
           //Startalocaltransaction.
           transaction=connection.BeginTransaction("SampleTransaction");
           //Mustassignbothtransactionobjectandconnection
           //toCommandobjectforapendinglocaltransaction
           command.Connection=connection;
           command.Transaction=transaction;
           try
           {
               command.CommandText="InsertintoRegion(RegionID,RegionDescription)VALUES(100,"Description")";
               command.ExecuteNonQuery();
               command.CommandText= "InsertintoRegion(RegionID,RegionDescription)VALUES(101,"Description")";
               command.ExecuteNonQuery();
               //Attempttocommitthetransaction.
               transaction.Commit();
               Console.WriteLine("Bothrecordsarewrittentodatabase.");
           }
           catch(Exceptionex)
           {
               Console.WriteLine("CommitExceptionType:{0}",ex.GetType());
               Console.WriteLine(" Message:{0}",ex.Message);
               //Attempttorollbackthetransaction.
               try
               {
                   transaction.Rollback();
               }
               catch(Exceptionex2)
               {
                   //Thiscatchblockwillhandleanyerrorsthatmayhaveoccurred
                   //ontheserverthatwouldcausetherollbacktofail,suchas
                   //aclosedconnection.
                   Console.WriteLine("RollbackExceptionType:{0}",ex2.GetType());
                   Console.WriteLine(" Message:{0}",ex2.Message);
               }
           }
       }
   }