DataTable dt = new DataTable(); dt.Columns.Add("ID",typeof(string)); dt.Columns.Add("Name", typeof(string)); DataRow dr = dt.NewRow(); dr["ID"] = "1"; dr["Name"] = "Test1"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["ID"] = "2"; dr["Name"] = "Test2"; dt.Rows.Add(dr); DataTable dt1 = new DataTable(); dt1.Columns.Add("ID", typeof(string)); dt1.Columns.Add("Product", typeof(string)); dr = dt1.NewRow(); dr["ID"] = "1"; dr["Product"] = "Test-Product"; dt1.Rows.Add(dr); dataGridView1.DataSource = dt; dataGridView2.DataSource = dt1; var c = from p in dt.AsEnumerable() join d in dt1.AsEnumerable() on p.Field<string> ("ID") equals d.Field<string>("ID") select new { ID = p.Field<string>("ID"), Name = p.Field<string>("Name"), Product = d.Field<string>("Product")};
dataGridView3.DataSource = c.CopyToDataTable<DataRow>();
dataGridView3.DataSource = c;
ToList
dataGridView3.DataSource = c.ToList();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)