How may i use File.exists in Datatable.select expression [duplicate]

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.

Adil · Accepted Answer · 2016-03-02 07:14:11Z

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 2, 2016 at 7:14

Adil

148k25 gold badges217 silver badges207 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin Liversage · Accepted Answer · 2016-03-02 07:14:18Z

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 2, 2016 at 7:14

Martin Liversage

107k24 gold badges216 silver badges263 bronze badges