private void btnDelete_Click(object sender, EventArgs e)
{
string delete = "delete from tblNhanVien where MaNV=N'" + txtMaNV.Text + "'";
if (MessageBox.Show("Bạn có muốn xóa không", "Xóa dữ liệu", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
mydt.runQuery(delete);
}
gridViewHSNV.Refresh();
mydt.loaddata(gridViewHSNV, "select * from tblNhanVien");
}
private void btnXem_Click(object sender, EventArgs e)
{
mydt.loaddata(gridViewChamCong, " select cc.MaNV, HoTen, TinhTrang from tblChiTietChamCong cc inner join tblNhanVien nv on cc.MaNV = nv.MaNV where NgayCong = '" + dateCong.Text + "'");
}
