This method is not returning anything. The column QtyOnHand is the second column in the mySQL table, and has data.
public static int GetQtyOnHand(string aMed)
MySqlCommand cmd = new MySqlCommand();
con = new MySqlConnection("server=localhost;database=mydb;uid=root;pwd=;pooling=false;");
cmd.CommandText = "SELECT QtyOnHand FROM medstable WHERE AnesthMedName = '" + aMed + "'" ;
cmd.Connection = con;
int qtyOnHand = Convert.ToInt32(cmd.ExecuteScalar());