LinQ

var qry1 = datatable1.AsEnumerable().Select(a => new { MobileNo = a[“ID”].ToString() }); var qry2 = datatable2.AsEnumerable().Select(b => new { MobileNo = b[“ID”].ToString() }); var exceptAB = qry1.Except(qry2); DataTable dtMisMatch = (from a in datatable1.AsEnumerable() join ab in exceptAB on a[“ID”].ToString() equals ab.MobileNo select a).CopyToDataTable(); Kaynak: CodeProject

var difList = list1.Where(a => !list2.Any(a1 => a1.id == a.id)) .Union(list2.Where(a => !list1.Any(a1 => a1.id == a.id)));   Kaynak : StackOverFlow

var results = from myRow in dt.AsEnumerable() select myRow[“Field”].ToString(); ddlControl.DataSource = results.Distinct().ToList();