private void itemsListBox_SelectedIndexChanged(object sender, EventArgs e) { QuantityUpDown.ResetText(); txtTotal.Clear(); String text = itemsListBox.GetItemText(itemsListBox.SelectedItem); txtItemName.Text = text; query = "select price from items where item_name = '" + text + "'"; DataSet ds = fn.getData(query); try { txtPrice.Text = ds.Tables[0].Rows[0][0].ToString(); } catch { } }