I have a datatable lets say Dt_Amount . This Dt_Amount has a column Amount .I need to filter Dt_Amount where Amount is greater than 0 .But here Amount is coming as string .How to filter Amount>0 in this in filter datatable.

Filterdatatable convert string into Int

Anil_G (Anil Gorthi) November 22, 2022, 10:31am 9

use like this

dt.AsEnumberable.Where(Function(x) CDBL(x(“Amount”).Tostring.Replace("""",""))>0).CopyToDatatable

cheers

Topic		Replies	Views
How to convert String to int? Activities excel , activities , question	5	2897	April 5, 2022
Issue with filter datatable Help	16	6569	October 29, 2018
Filter Datatable: Conversion from string to Int not valid Studio	5	1776	February 12, 2022
Filter dt by double precision numbers Studio datatable , excel , studio	15	1834	September 13, 2021
Datable Column as string. Need as Integer Help	7	7677	August 13, 2020