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;
}
}
