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