protected void Page_Load(object sender, EventArgs e)
        {
            _category = Request.QueryString["category"];

            CategoryLabel.Text = _category;

            var productBL = new ProductBL();
            var productList = productBL.GetCategoryList(_category);

            var dt = new DataTable();
            var dcImage = new DataColumn("Image", typeof(string));
            var dcProductName = new DataColumn("Product Name", typeof(string));
            var dcDescription = new DataColumn("Description", typeof(string));
            var dcPrice = new DataColumn("Price", typeof(string));

            dt.Columns.AddRange(new[] { dcImage, dcProductName, dcDescription, dcPrice });

            for (var i = 0; i < productList.Count; i++)
            {
                dt.Rows.Add(new object[]
                    {
                        productList.ElementAt(i).GetImage().Trim(), productList.ElementAt(i).GetProductName().Trim(),
                        productList.ElementAt(i).GetDescription().Trim(), productList.ElementAt(i).GetPrice().Trim()
                    });
            }

            ToysTreatsAndVitaminsGrid.DataSource = dt;
            ToysTreatsAndVitaminsGrid.DataBind();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            _category = Request.QueryString["category"];
            if (_category.Equals("dry"))
            {
                _category = "Dry Food";
            }
            else if(_category.Equals("wet"))
            {
                _category = "Wet Food";
            }

            FoodCategoryLabel.Text = _category;

            var productBL = new ProductBL();
            var productList = productBL.GetCategoryList(_category);

            var dt = new DataTable();
            var dcImage = new DataColumn("Image", typeof(string));
            var dcProductName = new DataColumn("Product Name", typeof(string));
            var dcBrand = new DataColumn("Brand", typeof(string));
            var dcDescription = new DataColumn("Description", typeof(string));
            var dcWeight = new DataColumn("Weight", typeof(string));
            var dcPrice = new DataColumn("Price", typeof(string));

            dt.Columns.AddRange(new[] { dcImage, dcProductName, dcBrand, dcDescription, dcWeight, dcPrice });

            for (var i = 0; i < productList.Count; i++)
            {
                dt.Rows.Add(new object[]
                    {
                        productList.ElementAt(i).GetImage().Trim(), productList.ElementAt(i).GetProductName().Trim(),
                        productList.ElementAt(i).GetBrand().Trim(), productList.ElementAt(i).GetDescription().Trim(),
                        productList.ElementAt(i).GetWeight().Trim(), productList.ElementAt(i).GetPrice().Trim()
                    });
            }

            FoodGrid.DataSource = dt;
            FoodGrid.DataBind();
        }