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