public OleDbDataReader LayDSKhoaReader()
{
string sql = "SELECT IDKhoa, TenKhoa "
+ "FROM tKhoa ";
OleDbDataReader reader = conn.GetDataReader(sql);
return(reader);
}
public OleDbDataReader LayDSMonHocReader(string idKhoa)
{
string sql = "SELECT m.IDMonHoc, m.IDKhoa, m.MaMonHoc, m.TenMonHoc, n.TenKhoa "
+ "FROM tMonHoc m "
+ "INNER JOIN tKhoa n ON m.IDKhoa = n.IDKhoa "
+ "WHERE m.IDKhoa='" + idKhoa + "'";
return(conn.GetDataReader(sql));
}
public OleDbDataReader LayDSNhomCauHoiTheoMHReader(string maMonHoc)
{
string sql = "SELECT m.ID, m.TenFile, m.IDMonHoc, "
+ " n.MaMonHoc, n.TenMonHoc, n.IDKhoa, k.TenKhoa "
+ " FROM (tNhom m "
+ " INNER JOIN tMonHoc n ON m.IDMonHoc = n.IDMonHoc) "
+ " INNER JOIN tKhoa k ON n.IDKhoa = k.IDKhoa "
+ " WHERE n.MaMonHoc='" + maMonHoc + "' "
+ " GROUP BY m.ID, m.TenFile, m.IDMonHoc, n.MaMonHoc, n.TenMonHoc, n.IDKhoa, k.TenKhoa";
return(conn.GetDataReader(sql));
}