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