private void btnLocSV_Click(object sender, EventArgs e) { DataTable xeploai = new DataTable(); double DiemTBC = 0, DiemRenLuyen = 0; if (txtDiemTBC.Text.Trim() != "" && txtDiemRenLuyenTu.Text != "") { DiemRenLuyen = double.Parse("0" + txtDiemRenLuyenTu.Text.Trim()); DiemTBC = double.Parse("0" + txtDiemTBC.Text.Trim()); DataSet ds = oBSV_SinhVien.GetDSXetHocBong(pDM_LopInfo, Program.NamHoc, Program.HocKy, Program.IDNamHoc, DiemRenLuyen, DiemTBC); dtSinhVien = ds.Tables[0]; dtChiTiet = ds.Tables[1]; xeploai = ds.Tables[2]; if (xeploai.Rows.Count > 0) { for (int i = 0; i < xeploai.Rows.Count; i++) { if (xeploai.Rows[i]["XepLoai"].ToString() == "Xuất sắc") { xuatsac = xeploai.Rows[i]["Tong"].ToString(); } else if (xeploai.Rows[i]["XepLoai"].ToString() == "Giỏi") { gioi = xeploai.Rows[i]["Tong"].ToString(); } else if (xeploai.Rows[i]["XepLoai"].ToString() == "Khá") { kha = xeploai.Rows[i]["Tong"].ToString(); } else if (xeploai.Rows[i]["XepLoai"].ToString() == "TB Khá") { TBKha = xeploai.Rows[i]["Tong"].ToString(); } else if (xeploai.Rows[i]["XepLoai"].ToString() == "Trung bình") { trungbinh = xeploai.Rows[i]["Tong"].ToString(); } else { Kem = xeploai.Rows[i]["Tong"].ToString(); } } txtXuatSac.Text = string.Format("{0:N2}%", float.Parse("0" + (float.Parse("0" + xuatsac) * 100 / dtChiTiet.Rows.Count))); txtGioi.Text = string.Format("{0:N2}%", float.Parse("0" + (float.Parse("0" + gioi) * 100 / dtChiTiet.Rows.Count).ToString())); txtKha.Text = string.Format("{0:N2}%", float.Parse("0" + (float.Parse("0" + kha) * 100 / dtChiTiet.Rows.Count).ToString())); txtTBKha.Text = string.Format("{0:N2}%", float.Parse("0" + (float.Parse("0" + TBKha) * 100 / dtChiTiet.Rows.Count).ToString())); txtTrungBinh.Text = string.Format("{0:N2}%", float.Parse("0" + (float.Parse("0" + trungbinh) * 100 / dtChiTiet.Rows.Count))); txtKem.Text = string.Format("{0:N2}%", float.Parse("0" + (float.Parse("0" + Kem) * 100 / dtChiTiet.Rows.Count).ToString())); } else { txtXuatSac.Text = ""; txtGioi.Text = ""; txtKha.Text = ""; txtTBKha.Text = ""; txtTrungBinh.Text = ""; txtKem.Text = ""; } grdDanhSach.DataSource = dtSinhVien; } else { ThongBao("Chưa nhập điều kiện xét học bổng!"); } }