What is the LINQ query to exclude data from Excel 'column 4' which are ending with 0?

Build
, ,
#1

LINQ query to exclude data from Excel ‘column 4’ which are ending with 0?

#2

@mohd
give a try on
(From d In yourDataTableVar.AsEnumerable
Where Not d(“column 4”).toString.EndWith(“0”)).CopyToDataTable

Kindly Note:

  • Excel was read in into a datatable
  • System.Data.DataSetExtension is imported
  • CopyToDataTable throws an exception in case of no rows are returned from the stetement
2 Likes
#3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.