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

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

@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

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