private void FrmEdoCta_Load(object sender, EventArgs e) { try { grdDatos.AutoGenerateColumns = false; using (Profit_RGEntities context = new Profit_RGEntities()) { var Empresas = (from emp in Ldetalle select new { empresa = emp.empresa.Trim(), nro_viaje = emp.nro_viaje }).Distinct().ToList(); List <EdoCta> Ledocta = new List <EdoCta>(); foreach (var item in Empresas) { var Ltemp = context.pEdoCtaxViaje(item.empresa.Trim(), item.nro_viaje).ToList(); foreach (var item0 in Ltemp) { Ledocta.Add(new EdoCta { Empresa = item.empresa, Co_prov = item0.co_prov, Prov_des = item0.prov_des, Fact_num = item0.fact_num, Monto = item0.monto, Abono = item0.abono, Saldo = item0.saldo }); } } grdDatos.DataSource = Ledocta.ToList(); } } catch (EntityException ex) { MessageBox.Show(ex.InnerException.Message, "Profit Expansion", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex1) { MessageBox.Show(ex1.Message, "Profit Expansion", MessageBoxButtons.OK, MessageBoxIcon.Error); } }