protected void CategoryId_SelectedIndexChanged(object sender, EventArgs e)
        {
            ProductEntities obj_BEProduct = new ProductEntities();

            obj_BEProduct.CategoryId = Convert.ToInt16(CategoryId.SelectedItem.Value);

            DataTable dt1           = new DataTable();
            BAProduct obj_BAProduct = new BAProduct();

            dt1 = obj_BAProduct.BA_GetBrandFromCategory(obj_BEProduct);

            BrandId.DataSource     = dt1;
            BrandId.DataTextField  = "BrandName";
            BrandId.DataValueField = "BrandId";

            BrandId.DataBind();
            BrandId.Items.Insert(0, new ListItem("--Select Brand--", "0"));
        }