private DataSet vDsKetQuaHocTap() { tb = new DataTable(); boHv = new BO_HOCVIEN(); vDsBieuMau = new DsInBieuMau(); int vLopID = int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString()); int vMonID = int.Parse(lookMonHoc.GetColumnValue("MON_ID").ToString()); int vLanThi = int.Parse(lookLanThi.GetColumnValue("DIE_LanThi").ToString()); tb = boHv.ExportExcel_DiemThi(vLopID, vMonID, vLanThi); if (tb.Rows.Count > 0) { for (int i = 0; i < tb.Rows.Count; i++) { vRow = vDsBieuMau.DiemDanhHocVien.NewRow(); vRow["STT"] = i + 1; vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString(); vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString(); vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString(); vRow["TIN_Name"] = tb.Rows[i]["TIN_Name"].ToString(); vRow["vLopName"] = lookLop_InGCN.GetColumnValue("LOP_Name").ToString(); vRow["vMonName"] = lookMonHoc.GetColumnValue("MON_Name").ToString(); vDsBieuMau.DiemDanhHocVien.Rows.Add(vRow); } } return(vDsBieuMau); }