private void listBox2_SelectedIndexChanged(object sender, EventArgs e)
{
DbHandler dbh = new DbHandler();
dbh.refreshListBox(listBox1, "foodChange", searchResults[listBox2.SelectedIndex]);
SqlDataReader sdr = dbh.read("select * from Food where id=" + searchResults[listBox2.SelectedIndex]);
sdr.Read();
comboBox1.SelectedValue = sdr.GetInt32(1);
comboBox3.SelectedValue = sdr.GetInt32(3);
}
public DeleteFood()
{
InitializeComponent();
label6.Visible = false;
DbHandler dbh = new DbHandler();
dbh.addItemsToComboBox(comboBox3, 0, 1, "HowPrepare", 2);
dbh.addItemsToComboBox(comboBox1, 0, 1, "MeasurementUnits", -1);
dbh.addItemsToComboBox(comboBox4, 0, 2, "Food", -1);
dbh.refreshListBox(listBox1, "foodChange", (int)comboBox4.SelectedValue);
}
