select DISTINCT targeturl from internal where TargetURL NOT in (select DISTINCT url from Internal)
var List1 = dt.AsEnumerable().Select(c => c.Field<string>("URL")).Distinct().ToList(); var List2 = dt.AsEnumerable().Select(c => c.Field<string>("TargetURL")).Distinct().ToList(); var Targetname = List2.Except(List1.ToList()).ToList();
DataTable dstdt = dt.AsEnumerable().Select(c => c.Field<string>("TargetURL")) .Except(dt.AsEnumerable().Select(c=>c.Field<string>("Url"))) .Distinct().CopyToDataTable();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)