private void LoadSinhVien_Lop()
        {
            int trangThaiLayDanhSach = 1;

            switch (cboDanhSachHienThi.SelectedIndex)
            {
            case 0:
                trangThaiLayDanhSach = 1;
                break;

            case 1:
                trangThaiLayDanhSach = 2;
                break;

            case 2:
                trangThaiLayDanhSach = 0;
                break;
            }

            dtSinhVien = oBSV_SinhVien.GetByLop(IDDM_Lop, trangThaiLayDanhSach);
            if (!dtSinhVien.Columns.Contains("HoVa"))
            {
                dtSinhVien.Columns.Add("HoVa", typeof(string));
            }
            string HoDem = "";

            foreach (DataRow dr in dtSinhVien.Rows)
            {
                GetTen(dr["HoVaTen"].ToString(), ref HoDem);
                dr["HoVa"] = HoDem;

                if (dr["KhenThuong"] + "" != "")
                {
                    dr["KhenThuong"] = string.Join("\n", dr["KhenThuong"].ToString().Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries));
                }
                if (dr["KyLuat"] + "" != "")
                {
                    dr["KyLuat"] = string.Join("\n", dr["KyLuat"].ToString().Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries));
                }
            }
            dtSinhVien.AcceptChanges();
            grdSinhVien.DataSource = dtSinhVien;
            lblSySo.Text           = "Sỹ số: " + dtSinhVien.Rows.Count.ToString();
        }
 private void LoadSinhVien_Lop()
 {
     dtSinhVien = oBSV_SinhVien.GetByLop(IDDM_Lop, 1);
     grdDanhSachSV.DataSource = dtSinhVien;
 }