private void UpdateDataGridCliente() { int idperson; int idDireccion; int idUser; var cliente = client.GetCliente(); var user = client.GetUsers(); var direccion = client.GetDirecciones(); var persone = client.GetPersonas(); var zona = client.GetZonas(); List <Clian> clis = new List <Clian>(); foreach (var c in cliente) { idperson = (from p in persone where p.idPersona == c.idPersona select p.idPersona).ElementAt(0); int personiddicreccion = (from p in persone where p.idPersona == c.idPersona select p.idDireccion).ElementAt(0); idDireccion = (from d in direccion where d.idDireccion == personiddicreccion select d.idDireccion).ElementAt(0); int idzona = (from d in direccion where d.idDireccion == idDireccion select d.idZona).ElementAt(0); idUser = (from u in user where u.IdUser == c.IdUser select u.IdUser).ElementAt(0); Clian cli = new Clian { IdCliente = c.idCliente, PuntoFidelizacion = (int)c.puntoFidelizacion, PrimerNombre = (from p in persone where p.idPersona == idperson select p.primerNombre).ElementAt(0), SegundoNombre = (from p in persone where p.idPersona == idperson select p.segundoNombre).ElementAt(0), PrimerApellido = (from p in persone where p.idPersona == idperson select p.primerApellido).ElementAt(0), SegundoApellido = (from p in persone where p.idPersona == idperson select p.segundoApellido).ElementAt(0), Email = (from p in persone where p.idPersona == idperson select p.email).ElementAt(0), Nacionalidad = (from p in persone where p.idPersona == idperson select p.nacionalidad).ElementAt(0), FechaNacimiento = (from p in persone where p.idPersona == idperson select p.fechaNacimiento).ElementAt(0), Document = (from p in persone where p.idPersona == idperson select p.Documento).ElementAt(0), Telefono = (from p in persone where p.idPersona == idperson select p.telefono).ElementAt(0), Usuario = (from u in user where u.IdUser == c.IdUser select u.idUserName).ElementAt(0), Zona = (from z in zona where z.idZona == idzona select z.nombre).ElementAt(0), Apt = (from d in direccion where d.idDireccion == idDireccion select d.Apt).ElementAt(0), Casa = (from d in direccion where d.idDireccion == idDireccion select d.casa).ElementAt(0), Calle = (from d in direccion where d.idDireccion == idDireccion select d.calle).ElementAt(0) }; clis.Add(cli); } dataGridView1.DataSource = clis; }