multumesc a mers asa:

northwindDataContext db=new northwindDataContext(@"Data Source=APASCANU\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True");

var query = from c in db.Customers

join o in db.Orders

on c.CustomerID equals o.CustomerID

select new { c.CustomerID, c.CompanyName, o.OrderID };

//foreach (var result in query)

//{

// rez.WriteLine(result.CustomerID.ToString()+" "+ result.CompanyName.ToString()+ " " +result.OrderID.ToString());

//}

listBox1.DisplayMember = "CompanyName";

listBox1.ValueMember = "CustomerID";