public List <Student> GetStudentsInClass(string classID)
{
List <Student> listStudents = new List <Student>();
OleDbCommand cmd = dbconn.SqlCommand("SELECT * FROM student WHERE class_id=?", classID);
OleDbDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
listStudents.Add(StudentReader.Read(ref rd));
}
return(listStudents);
}
public Student GetStudentByID(string studentID)
{
OleDbCommand cmd = dbconn.SqlCommand("SELECT * FROM student WHERE id=?", studentID);
OleDbDataReader rd = cmd.ExecuteReader();
Student student = null;
while (rd.Read())
{
student = StudentReader.Read(ref rd);
}
return(student);
}
