Datable Column as string. Need as Integer

[ppr (Peter Preuss)]

I would suggest to start with the select method, could be easier to start with:

DataTable.Select Method (System.Data)

https://www.csharp-examples.net/dataview-rowfilter/

here the part Convert Function like: “Convert(total, ‘System.Int32’) = 2”

In Linq it would look like:

(From d In YourDataTableVar.AsEnumerable
Where CInt(d(YourColNameOrIndex).toString.Trim) = 5
Select d).CopyToDataTable

with the assumption that the filter result is not empty otherwise CopyToDataTable throws an exception. If there is a risk of empty result then it can be handled as here:

Select item in datatable

@Maroua302 check if one column of my datatable contains for example the name “john” can be interpretated in many directions: True if any row contains John in columnA dtData.AsEnumerable.Any(Function (x) x(“ColumnA”).toString.Contains(“John”)) *return all john rows dtData.AsEnumerable.Where(Function (x) x(“ColumnA”).toString.Contains(“John”)).toList dtData.Select(“[Name] LIKE ‘%john%’”).toList About the datarows and Copytodatatable: we can also expect that a filter result can be empty…