/// <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]);
            }
        }