Carrotware.CMS.DBUpdater.DatabaseUpdate.ExecNonQuery C# (CSharp) Method

        private Exception ExecNonQuery(string sConnectionString, string sSQLQuery, bool bIgnoreErr)
        {
            Exception exc = new Exception("");

            using (SqlConnection myConnection = new SqlConnection(sConnectionString)) {
                myConnection.Open();

                List<string> cmdLst = SplitScriptAtGo(sSQLQuery);

                if (!bIgnoreErr) {
                    try {
                        foreach (string cmdStr in cmdLst) {
                            using (SqlCommand myCommand = myConnection.CreateCommand()) {
                                myCommand.CommandText = cmdStr;
                                myCommand.Connection = myConnection;
                                myCommand.CommandTimeout = 360;
                                int ret = myCommand.ExecuteNonQuery();
                            }
                        }
                    } catch (Exception ex) {
                        exc = ex;
                    } finally {
                        myConnection.Close();
                    }
                } else {
                    StringBuilder sb = new StringBuilder();
                    foreach (string cmdStr in cmdLst) {
                        try {
                            using (SqlCommand myCommand = myConnection.CreateCommand()) {
                                myCommand.CommandText = cmdStr;
                                myCommand.Connection = myConnection;
                                myCommand.CommandTimeout = 360;
                                int ret = myCommand.ExecuteNonQuery();
                            }
                        } catch (Exception ex) {
                            sb.Append(ex.Message.ToString() + "\n~~~~~~~~~~~~~~~~~~~~~~~~\n");
                        }
                    }
                    exc = new Exception(sb.ToString());
                    myConnection.Close();
                }
            }

            return exc;
        }