public static void ExecuteQuery(string query, MysqlParameterCollection collection) { try { Connect(); MySqlCommand cmd = new MySqlCommand(query, connection); if (collection != null) { foreach (MySqlParameter param in collection.Parameters) cmd.Parameters.Add(param); } cmd.ExecuteNonQuery(); Disconnect(); } catch (System.Exception ex) { System.Console.WriteLine("\nDB ERROR: {0}", ex.Message); throw; } }
public static DataTable Select(string query, MysqlParameterCollection collection) { try { Connect(); MySqlCommand cmd = new MySqlCommand(query, connection); if (collection != null) { foreach (MySqlParameter param in collection.Parameters) cmd.Parameters.Add(param); } MySqlDataReader resultSet = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(resultSet); Disconnect(); return dt; } catch (System.Exception ex) { System.Console.WriteLine("\nDB ERROR: {0}", ex.Message); throw; } }