private void ShowSanPhamToDGV() { SanPhamBUL spb = new SanPhamBUL(); DanhMucBUL dmb = new DanhMucBUL(); List <DanhMucDTO> dsDanhMuc = dmb.DanhSach(); List <SanPhamDTO> dsSanPham = spb.DanhSach(); //Linq dgvSanPham.DataSource = (from sp in dsSanPham from dm in dsDanhMuc where sp.MaDanhMuc.Equals(dm.MaDanhMuc) select new { sp.MaSanPham, sp.TenSanPham, sp.DonGia, sp.SoLuong, sp.MaDanhMuc, dm.TenDanhMuc } ).ToList(); dgvSanPham.Columns["MaSanPham"].HeaderText = "Mã Sản Phẩm"; dgvSanPham.Columns["TenSanPham"].HeaderText = "Tên Sản Phẩm"; dgvSanPham.Columns["DonGia"].HeaderText = "Đơn Giá"; dgvSanPham.Columns["SoLuong"].HeaderText = "Số Lượng"; dgvSanPham.Columns["MaDanhMuc"].Visible = false; dgvSanPham.Columns["TenDanhMuc"].HeaderText = "Danh Mục"; dgvSanPham.PerformLayout(); }
private void FillDataDanhMuc() { DanhMucBUL dmb = new DanhMucBUL(); cboDanhMuc.DataSource = dmb.DanhSach(); cboDanhMuc.DisplayMember = "TenDanhMuc"; cboDanhMuc.ValueMember = "MaDanhMuc"; }