private void Form2_Load(object sender, EventArgs e)
{
northwindDataContext nt = new northwindDataContext();
dataGridView1.DataSource = from o in nt.Orders join emp in nt.Employees on o.EmployeeID equals emp.EmployeeID select new
{
emp.EmployeeID,
emp.Employees,
emp.EmployeeTerritories,
o.Customer,
o.CustomerID
};
}
private void Form1_Load(object sender, EventArgs e)
{
northwindDataContext nt = new northwindDataContext();
dataGridView1.DataSource = from c in nt.Customers join o in nt.Orders on c.CustomerID equals o.CustomerID select new
{
o.Customer,
o.CustomerID,
o.Employee,
c.ContactName,
c.ContactTitle,
c.Country,
c.Address
};
}
