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);
}