private void Window_Loaded(object sender, RoutedEventArgs e) { ex = new ExaminationEntities1(); std_result.ItemsSource = ex.GetSudentGrades(_stdId); StudentGradeResults.ItemsSource = ex.GetSudentGrades(_stdId).Select(p => new { Subject = p.crs_Name, Grade = p.grade }).ToList(); var stdObj = ex.selectStudents().Where(s => s.std_Id == _stdId).FirstOrDefault(); this.studentName.Text += $"{stdObj.std_FName} {stdObj.std_LName}"; }
private void courseIDandResults(object sender, RoutedEventArgs e) { String courseName = std_result.Text; var item = ex.GetSudentGrades(_stdId).Where(c => c.crs_Name == courseName).FirstOrDefault(); if (courseName == null) { StudentGradeResults.ItemsSource = ex.GetSudentGrades(_stdId).Select(p => new { Subject = p.crs_Name, Grade = p.crs_Name }).ToList(); } else { StudentGradeResults.ItemsSource = ex.GetSudentGrades(_stdId).Where(p => p.crs_Name == courseName).Select(p => new { Subject = p.crs_Name, Grade = p.grade }).ToList(); } }