
Linq 11
By:
Milotronik on
Jun 7th, 2012 | syntax:
ASP | size: 1.03 KB | hits: 35 | expires: Never
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _11 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataClassesDataContext db = new DataClassesDataContext();
var qry = from emp in db.Employees
join dat in db.Customers on emp.City equals dat.City
select new {FirstName = emp.FirstName,
LastName = emp.LastName,
CompanyName = dat.CompanyName,
ContactName = dat.ContactName
};
GridView1.DataSource = qry;
GridView1.DataBind();
}
/*
* Mediante el uso de la clausula join seleccione los campos LastName y
FirstName de la tabla Employees y los campos ContactName y
Company Name que sean de la misma ciudad (City). Muestre los
resultados en un GridView.
*/
}