事务处理Transaction

SqlTransaction tranInsert;
private void TransactionInsert()
  {
   string ConnectString = ConfigurationSettings.AppSettings["XXX"];
   SqlConnection Con = new SqlConnection(ConnectString);

 

   try
   {
      Con.Open();
      SqlTransaction tranInsert = Con.BeginTransaction();
      Cmd = Con.CreateCommand();
      Cmd.Transaction = tranInsert;

 

      。。。。。。

 

      Cmd.ExecuteNonQuery();       
      tranInsert.Commit();
   }
   catch(Exception e)
   {
    tranInsert.Rollback();
   }
   finally
   {
      Con.Close();
   }