/// <summary> /// This method insert values of products from chosen category /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { DataBaseConnection dbc = new DataBaseConnection(); Product.Items.Clear(); // dbc.ConnectoToSQL(); string category = ProductClass.GetItemText(ProductClass.SelectedItem); Product_List = dbc.getProducts(category, Product_Class); Product.Items.Add("All"); Product.Items.Add("Any one"); int numOfItems = Product_List.Count(); for (int i = 0; i < numOfItems; i++) { Product.Items.Add(Product_List[i]); } }