public static DataTable Find(String key, bool bysbd) { string cmd = ""; if (!key.Equals("")) { if (bysbd) { cmd = "Select * from ThiSinh where MsThiSinh='" + key + "'"; } else { cmd = "Select* from ThiSinh where Upper(Ho) LIKE Upper('%" + key + "%') OR(Upper(Ten) LIKE Upper('%" + key + "%'))ORDER BY Ten"; } } else { cmd = "Select * from ThiSinh"; } return(ConnectDB.execAdapter(cmd)); }
public static DataTable DanhSachChuDe() { String cmd = "SELECT * FROM[ThiB2].[dbo].[ChuDeCauHoi]"; return(ConnectDB.execAdapter(cmd)); }
public static DataTable DanhSachCauHoiByChuDe(String key) { string cmd = "SELECT * FROM[ThiB2].[dbo].[View_DanhSachCauHoi] Where [MsChuDe]='" + key + "' "; return(ConnectDB.execAdapter(cmd)); }
public static DataTable ThongTinThiSinh(String sbd) { string cmd = "select Ho,Ten,NgaySinh,Case (GioiTinh) When 1 then 'Nam' When 0 then 'Nữ' end as GioiTinh,DiaChi,QuocTich,CMND,HinhAnh from ThiSinh where MsThiSinh='" + sbd + "'"; return(ConnectDB.execAdapter(cmd)); }
public static DataTable table_BaiThi(String MsThiSinh, String MsBaiThi) { string cmd = "select * from KiemtraMBT('" + MsThiSinh + "','" + MsBaiThi + "') "; return(ConnectDB.execAdapter(cmd)); }
public static DataTable table_DotThi(String dotThi) { string cmd = "select * from DotThi where MaBT='" + dotThi + "'"; return(ConnectDB.execAdapter(cmd)); }
public static DataTable table_ThiSinh(String thisinh) { string cmd = "select * from ThiSinh where MsThiSinh='" + thisinh + "'"; return(ConnectDB.execAdapter(cmd)); }