LINQ - Linq to Datatables

DataClasses1DataContext dcx = new DataClasses1DataContext(connectionString);
        dcx.Log = Console.Out;

        var orders = from ord in dcx.Orders
             where ord.OrderDate.Value.Year == 1998
             orderby ord.CustomerID, ord.OrderDate
             select new {
               Order_ID = ord.OrderID,      // can just use ord.OrderID
               Customer_ID = ord.CustomerID,  // field name reassignment is optional
               Order_Date = ord.OrderDate  
             };

        this.dataGridView1.DataSource = orders.ToList();

// Join 3 tables and show couple fields from each

        DataClasses1DataContext dcx = new DataClasses1DataContext(connectionString);

        var joined = from ord in dcx.Orders             // Inner Join
                join detail in dcx.Order_Details
                  on ord.OrderID equals detail.OrderID
                join product in dcx.Products
                  on detail.ProductID equals product.ProductID
          select new {
               ord.OrderID,
               ord.CustomerID,
               ord.OrderDate,
               detail.UnitPrice,
               detail.Quantity,
               product.ProductName
             };

        this.dataGridView1.DataSource = joined.ToList();

Hai


Instead Of using the Linq to Datatable U Can use the dataset Merge Concept Like this:
------------------------------------------------------------------------------------------------------------
For Eg tablename1,tablename2 Contains like this records:
----------------------------------------------------------------

TBLKEY EMPKEY EMPNAME  tablename1