public void fetchClasses() { string qry = "Select * from Class"; SqlCommand cmd = new SqlCommand(); cmd.Connection = SMS.connect; cmd.CommandText = qry; SMS.connect.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ClassData class_ = new ClassData(); class_.Class_ID1 = (string)reader["Class_ID"]; class_.Class_Name1 = (string)reader["Class_Name"]; //class_.Courses1 = (string)reader["Courses"]; class_.Section1 = (string)reader["Section"]; class_.C_Group1 = (string)reader["C_Group"]; classes.Add(class_); } SMS.connect.Close(); }
public void loadCourses() { for (int i = 0; i < classes.Count; i++) { ClassData item = classes.ElementAt(i); txtTeacherClass.Items.Add(item.Class_ID1); } }