private void cmbMasothue_SelectedIndexChanged(object sender, EventArgs e) { if (cmbMasothue.SelectedIndex != -1) { string str; str = "select d.Mataisan,d.Tentaisan from tblThueNha as b join tblNha_TaiSan as c on b.Manha=c.MaNha " + "join tblTaiSan as d on c.Mataisan=d.Mataisan where b.Masothue='" + cmbMasothue.SelectedValue + "'"; DAO.FillDataToCombo(str, cmbTaisan, "Mataisan", "Tentaisan"); } cmbTaisan.Text = ""; }
private void cmbManha_SelectedIndexChanged(object sender, EventArgs e) { if (cmbManha.SelectedIndex != -1) { string str; str = "select distinct Makhach from tblThueNha where Manha = '" + cmbManha.SelectedValue + "' "; // MessageBox.Show(str); DAO.FillDataToCombo(str, cmbMakhach, "MaKhach", "MaKhach"); txtDienthoai.Text = DAO.GetFieldValues("select Dienthoai from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'"); txtTenchunha.Text = DAO.GetFieldValues("select Tenchunha from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'"); txtDiachinha.Text = DAO.GetFieldValues("select Diachi from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'"); txtLoainha.Text = DAO.GetFieldValues("select b.Tenloai from tblDanhMucNha as a join tblLoainha as b on a.Maloai=b.Maloai where a.Manha = '" + cmbManha.SelectedValue + "'"); txtDongiathue.Text = DAO.GetFieldValues("select Dongiathue from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'"); txtDoituongsudung.Text = DAO.GetFieldValues("select b.TenDTSD from tblDanhMucNha as a join tblDoiTuongSuDung as b on a.MaDTSD=b.MaDTSD where a.Manha = '" + cmbManha.SelectedValue + "'"); txtTinhtrang.Text = DAO.GetFieldValues("select Tinhtrang from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'"); txtGhichu.Text = DAO.GetFieldValues("select Ghichu from tblDanhMucNha where Manha = '" + cmbManha.SelectedValue + "'"); } }