public List <DTO_HTTT> SVKN_HTTT() { string sql = "select * from DS_SinhVien" + " where HQT_CSDL>4 and LT_CSDL>4 and TH_CSDL>4"; List <DTO_HTTT> dssv = new List <DTO_HTTT>(); try { kn.Mo(); SqlDataReader rd = kn.ExecuteReader(sql); while (rd.Read()) { DTO_HTTT sv = new DTO_HTTT(); sv.MSSV1 = rd["MSSV"].ToString(); sv.HQT_CSDL1 = double.Parse(rd["HQT_CSDL"].ToString()); sv.LT_CSDL1 = double.Parse(rd["LT_CSDL"].ToString()); sv.TH_CSDL1 = double.Parse(rd["TH_CSDL"].ToString()); dssv.Add(sv); } kn.Dong(); return(dssv); } catch { return(dssv); } }
public List <DTO_HTTT> hienThiHTTT(DTO_SinhVien[] ds) { List <DTO_HTTT> kq = new List <DTO_HTTT>(); for (int i = 0; i < ds.Length; i++) { DTO_HTTT cn = new DTO_HTTT(); cn.MSSV1 = ds[i].MSSV1; cn.HoTen1 = ds[i].HoTen1; cn.HQT_CSDL1 = ds[i].HQT_CSDL1; cn.LT_CSDL1 = ds[i].CSDL1; cn.TH_CSDL1 = ds[i].TH_CSDL1; kq.Add(cn); } return(kq); }