private void BindDropDowns(string path)
        {
            DataSet   ds;
            DataTable dt = XMLBo.GetStates(path);

            ddlState.DataSource     = dt;
            ddlState.DataValueField = "StateCode";
            ddlState.DataTextField  = "StateName";
            ddlState.DataBind();
            ddlState.Items.Insert(0, new ListItem("Select a State", "Select a State"));

            dt = XMLBo.GetAdviserBranchType(path);
            ddlBranchAssociateType.DataSource     = dt;
            ddlBranchAssociateType.DataValueField = "XABRT_BranchTypeCode";
            ddlBranchAssociateType.DataTextField  = "XABRT_BranchType";
            ddlBranchAssociateType.DataBind();
            ddlBranchAssociateType.Items.Insert(0, new ListItem("Select a Type", "Select a Type"));

            ds = adviserAssociateCategoryBo.GetAdviserAssociateCategory(advisorVo.advisorId);
            dt = ds.Tables[0];
            ddlAssociateCategory.DataSource     = dt;
            ddlAssociateCategory.DataValueField = "AssociateCategoryId";
            ddlAssociateCategory.DataTextField  = "AssociateCategoryName";
            ddlAssociateCategory.DataBind();
            ddlAssociateCategory.Items.Insert(0, new ListItem("Select Associate Category", "Select Associate Category"));
        }