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 + "'"); }