使用TransactionScope 实现事务管理

using (System.Transactions.TransactionScope updateTransaction = new System.Transactions.TransactionScope())
        {
            try
            {
                ProcesVerbalTableAdapters.dbcmxTableAdapter da = new ProcesVerbalTableAdapters.dbcmxTableAdapter();
                da.InsertQuery1();
            }
            catch
            {
                Response.Write("sdfsfd");
            }
            updateTransaction.Complete();
        }