public static DataTable fillData(ParameterisedQuery query, string queryString, bool skipError = false)
{
using (DataTable results = new DataTable("toReturn")) {
Exception e = null;
for (int i = 0; i < 10; i++)
{
try {
query.Fill(queryString, results);
query.ClearParams();
return(results);
} catch (Exception ex) {
e = ex; // try yet again
}
}
if (skipError)
{
return(results);
}
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
query.ClearParams();
return(results);
}
}
static void DoDatabaseCall(ParameterisedQuery query, string sql, bool createDB,
DataTable results, ReaderCallback callback, params object[] args)
{
BindParams(query, args);
string connString = Backend.ConnectionString;
Exception e = null;
for (int i = 0; i < 10; i++)
{
try {
if (callback != null)
{
query.ExecuteReader(sql, connString, callback);
}
else if (results == null)
{
query.Execute(sql, connString, createDB);
}
else
{
query.Fill(sql, connString, results);
}
query.ClearParams();
return;
} catch (Exception ex) {
e = ex; // try yet again
}
}
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + sql + "\r\n");
Server.ErrorLog(e);
}
public static void executeQuery(ParameterisedQuery query, string queryString, bool createDB = false)
{
Exception e = null;
for (int i = 0; i < 10; i++)
{
try {
query.Execute(queryString, createDB);
query.ClearParams();
return;
} catch (Exception ex) {
e = ex; // try yet again
}
}
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
query.ClearParams();
}
