private void PlaceOrderUC_Load(object sender, EventArgs e) { ItemTxtLb.Hide(); TotalPriceTxtLb.Hide(); TotalPriceTxtLb.Text = ""; UnitPriceTxtLb.Hide(); QuantityUpDown.Hide(); query = "select distinct category from items"; DataSet ds = db.getData(query); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { CategoryBox.Items.Add(ds.Tables[0].Rows[i][0].ToString()); } }
private void listBox_SelectedIndexChanged(object sender, EventArgs e) { QuantityUpDown.Value = 0; TotalPriceTxtLb.ResetText(); ItemTxtLb.Show(); UnitPriceTxtLb.Show(); String text = listBox.GetItemText(listBox.SelectedItem); ItemTxtLb.Text = text; query = "select price from items where name = '" + text + "'"; DataSet ds = db.getData(query); try { UnitPriceTxtLb.Text = ds.Tables[0].Rows[0][0].ToString() + "€"; QuantityUpDown.Show(); } catch { UnitPriceTxtLb.Hide(); } }