private void loadControl() { try { DataTable dtChiTietHD = new DataTable(); dtChiTietHD = ctbll.ShowChiTietHD(); dgvHienThiChiTietHD.DataSource = dtChiTietHD; DataTable dtMaHH = new DataTable(); dtMaHH = hhbll.ShowHang(); cboMaHH.DataSource = dtMaHH; DataTable dtMaNV = new DataTable(); dtMaNV = nvbll.ShowNhanVien(); cboMaNV.DataSource = dtMaNV; cboMaNV.DisplayMember = "MaNV"; cboMaNV.ValueMember = "MaNV"; DataTable dtMaKH = new DataTable(); dtMaKH = khbll.ShowKhachHang(); cboMaKH.DataSource = dtMaKH; cboMaKH.DisplayMember = "MaKH"; cboMaKH.ValueMember = "MaKH"; DataTable dtHoaDon = new DataTable(); dtHoaDon = hdbll.ShowHoaDon(); dgvHienThiHDon.DataSource = dtHoaDon; DataTable dtMaHD = new DataTable(); dtMaHD = hdbll.onLoadHoaDon(); cboMaHD.DataSource = dtMaHD; } catch (SqlException ex) { MessageBox.Show("Lỗi SQL!", "Erorr", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); return; } }
public void loadControl() { DataTable dtHangHoa = new DataTable(); dtHangHoa = hbus.ShowHang(); dgvhang.DataSource = dtHangHoa; DataTable dt1 = new DataTable(); dt1 = hbus.ShowHangloaihang(); cboMaLoai.DisplayMember = "MaLoai"; cboMaLoai.ValueMember = "TenLoai"; cboMaLoai.DataSource = dt1; DataTable dt2 = new DataTable(); dt2 = hbus.ShowHangnhacungcap(); cboMaNCC.DisplayMember = "MaNCC"; cboMaNCC.ValueMember = "TenNCC"; cboMaNCC.DataSource = dt2; }