private void GridViewSinhVien_CellClick(object sender, DataGridViewCellEventArgs e) { // if (tblSinhVien.Rows.Count == 0) // { // MessageBox.Show("Không có dữ liệu!", "Thông báo", MessageBoxButtons.OK, //MessageBoxIcon.Information); // return; // } txtMaSV.Text = GridViewSinhVien.CurrentRow.Cells["clmMaSV"].Value.ToString(); txtTenSV.Text = GridViewSinhVien.CurrentRow.Cells["clmTenSV"].Value.ToString(); string sql = "SELECT TenKhoa FROM Khoa WHERE MaKhoa='" + GridViewSinhVien.CurrentRow.Cells["clmMaKhoa"].Value.ToString() + "'"; string s1 = "SELECT TenLop FROM Lop WHERE MaLop='" + GridViewSinhVien.CurrentRow.Cells["clmMaLop"].Value.ToString() + "'"; string s2 = "SELECT TenQue FROM Que WHERE MaQue='" + GridViewSinhVien.CurrentRow.Cells["clmMaQue"].Value.ToString() + "'"; string s3 = "SELECT TenDanToc FROM DanToc WHERE MaDanToc='" + GridViewSinhVien.CurrentRow.Cells["clmMaDanToc"].Value.ToString() + "'"; string s4 = "SELECT TenChuyenNganh FROM ChuyenNganh WHERE MaChuyenNganh='" + GridViewSinhVien.CurrentRow.Cells["clmMaChuyenNganh"].Value.ToString() + "'"; string s5 = "SELECT TenHDT FROM HeDaoTao WHERE MaHDT='" + GridViewSinhVien.CurrentRow.Cells["clmMaHDT"].Value.ToString() + "'"; string s6 = "SELECT TenChucVu FROM ChucVu WHERE MaChucVu='" + GridViewSinhVien.CurrentRow.Cells["clmMaChucVu"].Value.ToString() + "'"; cmbMaKhoa.Text = DAO.getfieldvalues(sql); cmbMaLop.Text = DAO.getfieldvalues(s1); mtbNgaySinh.Text = GridViewSinhVien.CurrentRow.Cells["clmNgaySinh"].Value.ToString(); cmbMaQue.Text = DAO.getfieldvalues(s2); cmbMaDanToc.Text = DAO.getfieldvalues(s3); cmbMaChuyenNganh.Text = DAO.getfieldvalues(s4); cmbMaHDT.Text = DAO.getfieldvalues(s5); cmbMaChucVu.Text = DAO.getfieldvalues(s6); if (GridViewSinhVien.CurrentRow.Cells["clmGioitinh"].Value.ToString() == "Nam") { checkGioiTinh.Checked = true; } else { checkGioiTinh.Checked = false; } txtMaSV.Enabled = false; }