/// <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()); } } }