private void fillTable(string queryString, ref DataTable dt)
{
dt = new DataTable();
if (!connectionObj.OpenConnection())
{
MessageBox.Show("Server Connection Failure. :(");
return;
}
MySqlCommand cmd = new MySqlCommand(queryString, connectionObj.conn);
MySqlDataAdapter dAdapter = new MySqlDataAdapter(cmd);
try
{
dAdapter.Fill(dt);
if (QueryLogCheckBox.IsChecked == true)
{
File.AppendAllText(@ServerLogLocation, queryString + "\n");
}
}
catch (MySqlException ex)
{
MessageBox.Show("Invalid SQL String. \nSQL String : \"" + queryString + "\"");
return;
}
}
public static bool fillTable(string queryString, ref DataTable dt)
{
dt = new DataTable();
if (!connectionObj.OpenConnection())
{
MessageBox.Show("Server Connection Failure. :(");
return(false);
}
MySqlCommand cmd = new MySqlCommand(queryString, connectionObj.conn);
MySqlDataAdapter dAdapter = new MySqlDataAdapter(cmd);
try
{
dAdapter.Fill(dt);
return(true);
}
catch (MySqlException ex)
{
MessageBox.Show("Invalid SQL String. \nSQL String : \"" + queryString + "\"");
return(false);
}
}