public Form1() { InitializeComponent(); listView1.View = View.Details; listView1.Columns.Add("Name"); listView1.Columns.Add("Meal"); listView1.Columns.Add("Category"); listView1.Columns.Add("Day"); listView1.Columns.Add("Day Num"); try { conn.Open(); } catch (Exception ex) { MessageBox.Show("We cannot connect to the database", ex.Message); return; } Updates.updateSource(conn); Updates.updateDays(conn); Updates.updateCuisine(conn); Updates.updateMeal(conn); Updates.updateCategory(conn); Updates.updateSeason(conn); Updates.updateUnits(conn); Updates.updateIngredients(conn); }
// Add category button private void button3_Click(object sender, EventArgs e) { foreach (string cat in Updates.getCatagories()) { if (cat == comboBox1.Text) { MessageBox.Show("This ingredient category is already in the list"); return; } } string theCmd = "INSERT INTO Category (name) VALUES (\'" + comboBox1.Text + "\');"; cmd = new MySqlCommand(theCmd, conn); cmd.ExecuteNonQuery(); Updates.updateCategory(conn); MessageBox.Show("This category is added to the list"); }