C# (CSharp) CN.BeginTransaction Examples

Example #1

        public bool ExecuteTransaction()
        {
            if (!Connection())
            {
                return(false);
            }

            SqlTransaction transaction = CN.BeginTransaction();

            try
            {
                foreach (SqlCommand cmd in TransactionCommands)
                {
                    cmd.Transaction = transaction;
                    cmd.ExecuteNonQuery();
                }
                transaction.Commit();
                return(true);
            }
            catch (Exception ex)
            {
                transaction.Rollback();
                _error = ex.Message;
            }



            return(false);
        }