protected void Page_Load(object sender, EventArgs e) { /* Load all courses */ List <Course> allCourses = new List <Course>(); List <SchoolClass> allclasses = new List <SchoolClass>(); List <StudentEnrollmentEntry> allEnrollment = new List <StudentEnrollmentEntry>(); String dbConnectionString = ConfigurationManager.ConnectionStrings["SchoolLogicDatabase"].ConnectionString; using (SqlConnection connection = new SqlConnection(dbConnectionString)) { allCourses = Course.loadAllCourses(connection); allclasses = SchoolClass.loadAllClasses(connection); allEnrollment = StudentEnrollmentEntry.loadAllStudentEnrollment(connection); } /* Populate table */ tblCourses.Rows.Clear(); foreach (Course course in allCourses) { tblCourses.Rows.Add(addCourseTableRow(course)); tblCourses.Rows.Add(addClassTableHeaders()); int classCount = 0; foreach (SchoolClass thisClass in allclasses) { if (thisClass.courseid == course.id) { /* Figure out student enrollment */ foreach (StudentEnrollmentEntry studentEE in allEnrollment) { if (studentEE.classID == thisClass.classid) { thisClass.enrollmentCount++; } } tblCourses.Rows.Add(addClassTableRow(thisClass)); classCount++; } } if (classCount == 0) { tblCourses.Rows.Add(addNoClassesRow()); } tblCourses.Rows.Add(addEmptyRow()); } lblClassCount.Text = allclasses.Count.ToString(); lblCourseCount.Text = allCourses.Count.ToString(); }