protected void DeptDDL_SelectedIndexChanged(object sender, EventArgs e) { using (WebhostEntities db = new WebhostEntities()) { List <int> courses = db.RequestableCourses.Where(rc => rc.TermId.Equals(TermId) && rc.Course.DepartmentID == SelectedDepartmentId).Select(rc => rc.id).ToList(); ClassDDL.DataSource = RequestableCourseListItem.GetDataSource(courses); ClassDDL.DataTextField = "Text"; ClassDDL.DataValueField = "ID"; ClassDDL.DataBind(); } }
/// <summary> /// Get a Datasource List for use in Web Controls. /// /// DataTextField = "Text" /// DataValueField = "Id" /// /// Invalid IDs are dropped without notification. /// /// </summary> /// <param name="actids">List of RequestableCourse.id</param> /// <returns></returns> public static List <RequestableCourseListItem> GetDataSource(List <int> actids) { List <RequestableCourseListItem> items = new List <RequestableCourseListItem>(); foreach (int id in actids) { RequestableCourseListItem item = new RequestableCourseListItem(id); if (item.ID != -1) { items.Add(item); } } return(items); }