Choose Category
using System.Linq;
public DataTable getLinq(DataTable dt1, DataTable dt2) { DataTable dtMerged = (from a in dt1.AsEnumerable() join b in dt2.AsEnumerable() on a["Query"].ToString() equals b["Query"].ToString() into g where g.Count() > 0 select a).CopyToDataTable(); return dtMerged; }
public DataTable getLinq(DataTable dt1, DataTable dt2) { DataTable dtMerged = (from a in dt1.AsEnumerable() join b in dt2.AsEnumerable() on a["Place"].ToString() equals b["Place"].ToString() into g where g.Count() > 0 select a).CopyToDataTable(); return dtMerged; }