How may i use File.exists in Datatable.select expression

Question

I have a datatable which contain a column Path of file. Now i want to filter file Path is exist or not.

DataTable.Select(File.Exists(ColumnsName))

Would you please help me how may i filter.

You search it in a specific column? – Soner Gönül Mar 02 '16 at 07:10 — Soner Gönül, Mar 02 '16 at 07:10
Yes, one column of that table contains file path – Sumit Kumar Mar 02 '16 at 07:12 — Sumit Kumar, Mar 02 '16 at 07:12

score 0 · Answer 1 · answered Mar 02 '16 at 07:14

0

You can filter datatable by file path column by checking existence using File.Exists

var result = dataTable.AsEnumerable().Where(r=>File.Exists(r.Field<string>("Path"));

answered Mar 02 '16 at 07:14

Adil

score 0 · Answer 2 · answered Mar 02 '16 at 07:14

0

DataSets are a pretty old concept in .NET so to use LINQ you need a bit of extra syntax:

dataTable.Rows.Cast<DataRow>().Select(row => File.Exists(row.Field<String>(columnName)))

This will return an IEnumerable<Boolean> that determines if the files exist.

answered Mar 02 '16 at 07:14

Martin Liversage

2 Answers2