public DataTable LoadDS()
{
string query = "SELECT * FROM dbo.MONHOC ";
DatabaseConnect dtConnet = new DatabaseConnect();
return(dtConnet.GETdata(query));
}
public DataTable LoadDS()
{
string query = "SELECT * FROM dbo.HOCSINH ";
return(dtConnect.GETdata(query));
}
public DataTable LoadDS(int ma)
{
string query = string.Format(" SELECT HS.MAHOCSINH , HOTEN, DIEMTBKY1 , DIEMTBKY2, DIEMTBCANAM FROM dbo.KETQUAHOCTAP kqht, dbo.HOCSINH HS WHERE kqht.MAHOCSINH = HS.MAHOCSINH and kqht.MALOP={0}", ma);
return(dtConnect.GETdata(query));
}
public DataTable dslop(int mahs)
{
string query = string.Format(" SELECT * FROM dbo.LOP WHERE MALOP IN ( SELECT MALOP FROM dbo.KETQUAHOCTAP kq WHERE kq.MAHOCSINH = {0})", mahs);
return(dtConnect.GETdata(query));
}
public DataTable LoadDS()
{
string query = "SELECT l.MALOP,l.TENLOP,l.SISO,l.MA_GVCHUNHIEM,gv.HOTEN FROM dbo.LOP l, dbo.GIAOVIEN gv WHERE l.MA_GVCHUNHIEM=gv.MAGIAOVIEN ";
return(dtConnect.GETdata(query));
}
public DataTable getTableAcc()
{
string query = "SELECT*FROM dbo.ACCOUNT";
return(dtconnect.GETdata(query));
}
public DataTable LayMonLop()
{
string query = "SELECT DISTINCT LopMon.MALOP, LopMon.TENLOP,LopMon.MAMONHOC, LopMon.TENMONHOC,gv.MAGIAOVIEN, gv.HOTEN FROM(SELECT l.MALOP,l.TENLOP,m.MAMONHOC, m.TENMONHOC, lm.MAGIAOVIEN FROM dbo.LOP l, dbo.MONHOC m, dbo.LOP_MON lm, dbo.GIAOVIEN gv WHERE l.MALOP = lm.MALOP AND m.MAMONHOC = lm.MAMONHOC)LopMon LEFT JOIN dbo.GIAOVIEN gv ON LopMon.MAGIAOVIEN = gv.MAGIAOVIEN";
return(dtConnect.GETdata(query));
}