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(); }
}
