Advertisement
Guest User

Untitled

a guest
Sep 18th, 2014
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. DataTable ModelData = getModelData() // Returns all records to search.
  2. ...
  3. EnumerableRowCollection<DataRow> modelRows = (from model in ModelData.AsEnumerable()
  4. where (model.Field<object>(GeographicalKey) ?? (object)String.Empty).ToString() == GeographicCode
  5. select model);
  6. ModelResults = modelRows.Any() ? modelRows.CopyToDataTable() : ModelData.Clone();
  7.  
  8. for (int i = 0; i < ModelResults.Rows.Count; i++)
  9. {
  10. for (int j = 0; j < ModelData.Rows.Count - 1; j++)
  11. {
  12. if (ModelResults.Rows[i]["Request ID"].ToString() == ModelData.Rows[j]["Request ID"].ToString())
  13. {
  14. ModelData.Rows[j]["Collected"] = "1";
  15. }
  16. }
  17. }
  18.  
  19. var collectedRequestIds = new HashSet<string>(
  20. modelResults.AsEnumerable().Select(row => row["Request ID"].ToString()));
  21.  
  22. modelData.AsEnumerable()
  23. .Where(collectedRequestIds.Contains(row => row["Request ID"].ToString())))
  24. .ToList().ForEach(row => row["Collected"] = "1");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement