private void XemNV(string sql) { //String sql = "SELECT nhanvien.ID, phongban.TENPHONG, HOTEN, NGAYSINH, CMND, DIACHI, DIENTHOAI, QUOCTICH, LOAI_NV, LUONGNGAY, LUONGTHANG, BACLUONG, TONGLUONG FROM nhanvien, phongban WHERE (nhanvien.ID_PHONG = phongban.ID)"; XemNVPresenter xemNVPresenter = new XemNVPresenter(this, sql); DataTable dt = new DataTable(); xemNVPresenter.getDA().Fill(dt); listNV_find.DataSource = dt; }
private void ButtonXem_Update_Click(object sender, EventArgs e) { String sql = "SELECT nhanvien.ID, phongban.TENPHONG, HOTEN, NGAYSINH, CMND, DIACHI, DIENTHOAI, QUOCTICH, LOAI_NV, LUONGNGAY, LUONGTHANG, BACLUONG, TONGLUONG FROM nhanvien, phongban WHERE (nhanvien.ID_PHONG = phongban.ID AND phongban.TENPHONG = '" + txtTenphong.Text + "')"; XemNVPresenter xem = new XemNVPresenter(this, sql); DataTable dt = new DataTable(); xem.getDA().Fill(dt); listNV_find.DataSource = dt; }