How to convert Data Column from String to Int64?

[snapval]

Hello everyone,

I have a datatable with three string columns (id, price, total). I need to convert just the column total to int64 so i can merge this table with another with the same types.

PS: i can’t use external packages.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@snapval
Int64.parse(total) would do this conversion

[Yoichi]

Hi,

Hope the following sample helps you.

dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r("id"),r("price"),r("total"),Int64.Parse(r("total").ToString())},False)).CopyToDataTable()

Sample20221206-2.zip (2.9 KB)

Regards,

[snapval]

You are a genius, thank you!