private void ClassAddTeacher_Load(object sender, EventArgs e) { RefreshTable(); List <Classes> ClassList = ClassesDB.ClassLoad(); List <Teacher> TeacherList = TeacherDB.TeacherLoad(); foreach (Classes classes in ClassList) { cmbClasses.Items.Add(classes.ClassID.ToString() + " " + classes.ClassTitle); } foreach (Teacher teacher in TeacherList) { cmbTeachers.Items.Add(teacher.TeacherID + " " + teacher.FirstName + " " + teacher.LastName); } }
public void RefreshTable() { dataGridView1.Rows.Clear(); dataGridView1.Refresh(); List <Classes> classList = ClassesDB.ClassLoad(); List <Teacher> teacherList = TeacherDB.TeacherLoad(); dataGridView1.ColumnCount = 7; dataGridView1.Columns[0].Name = "Class ID"; dataGridView1.Columns[1].Name = "Class Title"; dataGridView1.Columns[2].Name = "Class Track"; dataGridView1.Columns[3].Name = "Teacher"; dataGridView1.Columns[4].Name = "Teacher(s)"; dataGridView1.Columns[5].Name = "Teacher(s)"; dataGridView1.Columns[6].Name = "Teacher(s)"; foreach (Classes classes in classList) { string[] row; List <string> teacherNames = new List <string>() { "", "", "", "", "", "", "", "", "", "" }; int count = 0; foreach (int teacherid in classes.TeacherID) { if (teacherid != 0) { Teacher newTeacher = TeacherDB.TeacherFind(teacherid); teacherNames[count] = newTeacher.TeacherID.ToString() + " " + newTeacher.FirstName + " " + newTeacher.LastName; count++; } } row = new string[] { classes.ClassID.ToString(), classes.ClassTitle, classes.ClassTrack, teacherNames[0], teacherNames[1], teacherNames[2], teacherNames[3] }; dataGridView1.Rows.Add(row); } }