public static void ExecuteQuery(string qry)
{
//if (ConnectionStatus() == false || qry == "")
//{
MysqlInterface.close();
MysqlInterface.init();
//}
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = qry;
int numRowsUpdated = cmd.ExecuteNonQuery();
cmd.Dispose();
}
//string stm = "SELECT id, description, purchase_price FROM part"
public static MySqlDataReader DoQuery(string qry)
{
try
{
MysqlInterface.close();
MysqlInterface.init();
MySqlDataReader rdr = null;
MySqlCommand cmd = new MySqlCommand(qry, con);
rdr = cmd.ExecuteReader();
cmd.Dispose();
return(rdr);
}
catch (MySqlException err)
{
Console.WriteLine("Error: " + err.ToString());
return(null);
}
}
