public List <ChiTietLopHocDTO> tim_LopHocDAO(string HoTen) { List <ChiTietLopHocDTO> lst_LopHoc = new List <ChiTietLopHocDTO>(); SqlConnection conn = DataProvider.TaoKetNoi(); string query = "Select DD.MaLop, DD.MaHV, HV.HoTen, L.PhongHoc, L.MaTKB, DD.SoNgayVang, KQ.Nghe, KQ.Noi, KQ.Doc, KQ.Viet From DiemDanh DD, Lop L, HocVien HV, KetQua KQ Where HV.HoTen like '%" + HoTen + "%' and DD.MaLop = L.MaLop and DD.MaHV = KQ.MaHV and KQ.MaHV = HV.MaHV and L.MaLop = KQ.MaLop"; SqlDataReader sdr = DataProvider.ThucHienTruyVan(query, conn); while (sdr.Read()) { ChiTietLopHocDTO item = new ChiTietLopHocDTO(); item.MaLop = sdr["MaLop"].ToString(); item.MaHV = sdr["MaHV"].ToString(); item.HoTen = sdr["HoTen"].ToString(); item.PhongHoc = sdr["PhongHoc"].ToString(); item.MaTKB = sdr["MaTKB"].ToString(); item.SoNgayVang = int.Parse(sdr["SoNgayVang"].ToString()); item.Nghe = double.Parse(sdr["Nghe"].ToString()); item.Noi = double.Parse(sdr["Noi"].ToString()); item.Doc = double.Parse(sdr["Doc"].ToString()); item.Viet = double.Parse(sdr["Viet"].ToString()); lst_LopHoc.Add(item); } sdr.Close(); conn.Close(); return(lst_LopHoc); }
private void dgv_Lop_SelectionChanged(object sender, EventArgs e) { if (dgv_Lop.SelectedRows.Count > 0) { _HocVienDaChon = (ChiTietLopHocDTO)dgv_Lop.SelectedRows[0].DataBoundItem; } else { _HocVienDaChon = null; } BindingChiTietHocVien(); }