public List <Diemm> SearchSinhvienByMaLop(string malop) { List <Diemm> list = new List <Diemm>(); string qr = string.Format("SELECT * FROM dbo.Sinhvien WHERE malop = {0}", malop); DataTable data = DataProvider.Instance.ExecuteQuery(qr); foreach (DataRow item in data.Rows) { Diemm account = new Diemm(item); list.Add(account); } return(list); }
public List <Diemm> SearchSinhvienByDiem(string operation, float diem) { List <Diemm> list = new List <Diemm>(); string qr = string.Format("SELECT * FROM dbo.Diem WHERE diem {0} {1}", operation, diem); DataTable data = DataProvider.Instance.ExecuteQuery(qr); foreach (DataRow item in data.Rows) { Diemm account = new Diemm(item); list.Add(account); } return(list); }
public List <Diemm> GetDiemList() { List <Diemm> list = new List <Diemm>(); string qr = "SELECT masv, ho, ten, malop, phai, ngaysinh, noisinh, diachi, ghichu, nghihoc FROM dbo.Sinhvien"; DataTable data = DataProvider.Instance.ExecuteQuery(qr); foreach (DataRow item in data.Rows) { Diemm monhoc = new Diemm(item); list.Add(monhoc); } return(list); }
public List <Diemm> GetDiemList() { List <Diemm> list = new List <Diemm>(); string qr = @"SELECT d.masv, sv.ho, sv.ten, sv.phai, sv.malop, l.makh, d.mamh, mh.tenmh, lan, diem FROM dbo.Diem AS d INNER JOIN dbo.Sinhvien AS sv ON d.masv = sv.masv INNER JOIN dbo.Lop AS l ON l.malop = sv.malop INNER JOIN dbo.Khoa AS kh ON kh.makh = l.makh INNER JOIN dbo.Monhoc AS mh ON mh.mamh = d.mamh"; DataTable data = DataProvider.Instance.ExecuteQuery(qr); foreach (DataRow item in data.Rows) { Diemm monhoc = new Diemm(item); list.Add(monhoc); } return(list); }