LINQ query to exclude data from Excel ‘column 4’ which are ending with 0?
give a try on
(From d In yourDataTableVar.AsEnumerable
Where Not d(“column 4”).toString.EndWith(“0”)).CopyToDataTable
- 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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.