private void cmbFoodMenu_SelectedIndexChanged(object sender, EventArgs e) { if (cmbFoodMenu.SelectedIndex != -1) { try { cmbFoodMenu.BackColor = Color.White; SqlCommand sqlCmd = new SqlCommand("SP_getPriceWRTItem", Main.sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@m_id", Convert.ToInt32(cmbFoodMenu.SelectedValue.ToString())); Main.sqlCon.Open(); txtPrice.Text = Math.Round(Convert.ToDouble(sqlCmd.ExecuteScalar().ToString()), 0).ToString(); Main.sqlCon.Close(); Image img = FoodMenu.getItemImage(Convert.ToInt32(cmbFoodMenu.SelectedValue.ToString())); pbItemDiss.Image = img; pbItemDiss.SizeMode = PictureBoxSizeMode.Zoom; DataRowView drv = cmbFoodMenu.SelectedItem as DataRowView; Roles.LoadCategoryWRTItem(drv["MenuItem"].ToString()); } catch (Exception ex) { Main.sqlCon.Close(); Main.showMessage(ex.Message, "error"); } } else { txtPrice.Text = ""; txtPrice.BackColor = Color.White; pbItemDiss.Image = null; cmbFoodMenu.BackColor = Color.Firebrick; } }