Inner join of two datatables using linq

Try

DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();

// Here assumed both the datable are filled with some data
// Below linq query joins two table based on ID column and gets the resultset 

DataTable result = (from t1 in dt1.AsEnumerable()
                                    join t2 in dt2.AsEnumerable() on t1.Field<int>("id") equals t2.Field<int>("id")
                                   select t1).CopyToDataTable();

or have a read thread of "Create combined DataTable from two DataTables joined with LINQ"
http://stackoverflow.com/questions/2379747/create-combined-datatable-from-two-datatables-joined-with-linq-c

Thanks & Regards
Ravi Ranjan Kumar
http://raviranjankr.wordpress.com

Refer :

http://codingsense.wordpress.com/2009/03/08/left-join-right-join-using-linq/

http://forums.asp.net/t/1354584.aspx/1?How+to+join+two+tables+with+LINQ+inner+join+in+a+class+file+

http://stackoverflow.com/questions/525194/linq-inner-join-vs-left-join

Thanks & Regards,
Sasi Prabhu.