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();
}
