protected void Page_Load(object sender, EventArgs e) { IEnumerable <OrgListItem> dataSource = null; if (CurrentUser.HasPriv(ClientPrivilege.Administrator)) { IList <Org> allOrgs = DataSession.Query <Org>().ToList(); dataSource = allOrgs.Select(x => new OrgListItem() { OrgID = x.OrgID, OrgName = x.OrgName }).OrderBy(x => x.OrgName); } else if (CurrentUser.HasPriv(ClientPrivilege.Executive)) { var allClientOrgs = ContextBase.GetCurrentUserClientOrgs(); dataSource = allClientOrgs.Select(x => new OrgListItem() { OrgID = x.OrgID, OrgName = x.OrgName }).OrderBy(x => x.OrgName); } if (dataSource.Count() > 1) { ddlOrg.AppendDataBoundItems = true; } ddlOrg.DataSource = dataSource; ddlOrg.DataTextField = "OrgName"; ddlOrg.DataValueField = "OrgID"; ddlOrg.DataBind(); }