private void ShowVariants()
        {
            List <BLProduct> variantList = BLProduct.RetrieveVariantsOfProductFromDB(connectionString, product.Id);

            DropDownVariants.Items.Clear();
            ListItem selectedProduct = new ListItem(productTitle.InnerText, product.Id.ToString());

            DropDownVariants.Items.Add(selectedProduct);
            foreach (BLProduct variant in variantList)
            {
                ListItem item = new ListItem(variant.Name, variant.Id.ToString());
                DropDownVariants.Items.Add(item);
            }
        }