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 store button private void button4_Click(object sender, EventArgs e) { foreach (string store in Updates.getStores()) { if (store == comboBox2.Text) { MessageBox.Show("This store is already in the list"); return; } } string theCmd = "INSERT INTO Source (name) VALUES (\'" + comboBox2.Text + "\');"; cmd = new MySqlCommand(theCmd, conn); cmd.ExecuteNonQuery(); Updates.updateSource(conn); MessageBox.Show("This store is added to the list"); }