new protected void Page_Init(object sender, EventArgs e) { base.Page_Init(sender, e); using (WebhostEntities db = new WebhostEntities()) { StudentComboBox.DataSource = StudentListItem.GetDataSource( db.Students.Where(s => s.isActive).OrderBy(s => s.GraduationYear).ThenBy(s => s.LastName).ThenBy(s => s.FirstName).Select(s => s.ID).ToList()); StudentComboBox.DataTextField = "Text"; StudentComboBox.DataValueField = "ID"; StudentComboBox.DataBind(); } }
new protected void Page_Init(object sender, EventArgs e) { base.Page_Init(sender, e); using (WebhostEntities db = new WebhostEntities()) { Faculty faculty = db.Faculties.Find(user.ID); if (faculty == null) { LogError("Could not locate faculty id {0}", user.ID); Response.Redirect("~/Home.aspx"); } StudentComboBox.DataSource = StudentListItem.GetDataSource(faculty.Students.Where(s => s.isActive).Select(s => s.ID).ToList()); StudentComboBox.DataTextField = "Text"; StudentComboBox.DataValueField = "ID"; StudentComboBox.DataBind(); } }