/// <summary>
/// Executes a SELECT statement against the database,
/// and returns the result set in a data table
/// </summary>
/// <param name="sqlStatement"></param>
/// <returns></returns>
public static DataTable selectFromDatabase(sqlStatement sqlStatement)
{
using (MySqlConnection databaseConnection = new MySqlConnection(sqlStatement.connectionString))
{
databaseConnection.Open();
using (MySqlCommand command = new MySqlCommand(sqlStatement.query, databaseConnection))
{
if (sqlStatement.queryParameters != null)
{
foreach (KeyValuePair <string, object> parameter in sqlStatement.queryParameters)
{
command.Parameters.Add(new MySqlParameter(parameter.Key, parameter.Value));
}
}
using (MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command))
{
using (DataTable resultSet = new DataTable())
{
dataAdapter.Fill(resultSet);
return(resultSet);
}
}
}
}
}
/// <summary>
/// Executes a Non Query (Update, Delete, etc...) against the database,
/// and returns the number of rows affected
/// </summary>
/// <param name="sqlStatement"></param>
/// <returns></returns>
public static int executeNonQueryOnDatabase(sqlStatement sqlStatement)
{
using (MySqlConnection databaseConnection = new MySqlConnection(sqlStatement.connectionString))
{
databaseConnection.Open();
using (MySqlCommand command = new MySqlCommand(sqlStatement.query, databaseConnection))
{
if (sqlStatement.queryParameters != null)
{
foreach (KeyValuePair <string, object> parameter in sqlStatement.queryParameters)
{
command.Parameters.Add(new MySqlParameter(parameter.Key, parameter.Value));
}
}
return(command.ExecuteNonQuery());
}
}
}
