private void loadGrid() { CpfCnpjEntities1 context = new CpfCnpjEntities1(); GVMaterial.DataSource = context.Material.ToList <Material>(); GVMaterial.DataBind(); }
private void CarregarListaMaterial() { Aula5Entities context = new Aula5Entities(); var dados = ( from m in context.MATERIAL from f in context.FORNECEDOR.Where(x => x.id == m.id_fornecedor) from t in context.TIPO.Where(x => x.id == m.id_tipo) select new { Id = m.id, Descricao = m.descricao, Dataentrada = m.dataentrada, Id_tipo = t.descricao, Id_fornecedor = f.nome, Valor = m.valor }).ToList(); GVMaterial.DataSource = dados; GVMaterial.DataBind(); }