private void BindRolename()
        {
            DataTable dtRoles = new DataTable();

            advisorPreferenceBo = new AdviserPreferenceBo();
            dtRoles             = advisorPreferenceBo.GetAdviserRoles(advisorVo.advisorId).Tables[0];


            if (dtRoles.Rows.Count > 0)
            {
                ddlRole.DataSource     = dtRoles;
                ddlRole.DataValueField = dtRoles.Columns["AR_RoleId"].ToString();
                ddlRole.DataTextField  = dtRoles.Columns["AR_Role"].ToString();
                ddlRole.DataBind();
            }
            ddlRole.Items.Insert(0, new ListItem("Select", "Select"));
        }