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;
}