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.