public void BindDropdown()
        {
            BABrand   objBrand = new BABrand();
            DataTable dt       = new DataTable();

            dt = objBrand.BAGetCategory();
            ddlCategory.DataSource     = dt;
            ddlCategory.DataTextField  = "CategoryName";
            ddlCategory.DataValueField = "CategoryId";
            ddlCategory.DataBind();
            ddlCategory.Items.Insert(0, new ListItem("--Select Category--", "0"));
        }
        public void BindDropDown()
        {
            BABrand   objProduct = new BABrand();
            DataTable dt         = new DataTable();

            dt = objProduct.BAGetCategory();
            BrandId.Items.Insert(0, new ListItem("--Select Brand--", "0"));

            CategoryId.DataSource     = dt;
            CategoryId.DataTextField  = "CategoryName";
            CategoryId.DataValueField = "CategoryId";

            CategoryId.DataBind();
            CategoryId.Items.Insert(0, new ListItem("--Select Category--", "0"));
        }