public static void executeQuery(string queryString, bool createDB = false) { int totalCount = 0; retry : try { if (Server.useMySQL) { MySQL.execute(queryString, createDB); } else { if (!createDB) // Databases do not need to be created in SQLite. { SQLite.execute(queryString); } } } catch (Exception e) { if (!createDB || !Server.useMySQL) { totalCount++; if (totalCount > 10) { File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n"); Server.ErrorLog(e); } else { goto retry; } } else { throw e; } } finally { if (Server.useMySQL) { MySQL.ClearParams(); } else { SQLite.ClearParams(); } } }
public static DataTable fillData(string queryString, bool skipError = false) { int totalCount = 0; using (DataTable toReturn = new DataTable("toReturn")) { retry : try { if (Server.useMySQL) { MySQL.fill(queryString, toReturn); } else { SQLite.fill(queryString, toReturn); } } catch (Exception e) { totalCount++; if (totalCount > 10) { if (!skipError) { File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n"); Server.ErrorLog(e); } } else { goto retry; } } finally { if (Server.useMySQL) { MySQL.ClearParams(); } else { SQLite.ClearParams(); } } return(toReturn); } }