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);
}
}
