Convert selected columns in a datatable into integer using linq

[krishna_r]

Hello Everyone,

Need help with a quick linq query to convert selected string columns into interger type and store in a datatable variable

[arjunshenoy]

Hi @krishna_r

Please try this:

Assign activity:

datatableOutput = (From row In datatableInput.AsEnumerable()
Select datatableInput.Clone().Rows.Add(row.ItemArray.Select(Function (x) If(IsNumeric(x.ToString.Trim),Convert.ToInt32(x.ToString.Trim),x)).ToArray())).CopyToDataTable()

Hope this helps,
Best Regards.

[krishna_r]

@arjunshenoy

From row In datatableInput.AsEnumerable()
Select datatableInput.Clone().Rows.Add(row.ItemArray.Select(Function (x) If(IsNumeric(x.ToString.Trim),Convert.ToInt32(x.ToString.Trim),x)).ToArray())).CopyToDataTable()

error message: is numeric is not declared

[ppr (Peter Preuss)]

@krishna_r

error message: is numeric is not declared

A column defining a datatype of String cannot be populated with an int32

@krishna_r

Need help with a quick linq query to convert selected string columns into interger type and store in a datatable variable

• define a third column - e.g. colname Col3

• populate it with usage of

  • for each row …
    OR
  • a LINQ
    OR
  • data columns Expression
    OR as described here:
  • How to Update Data Column Values of a Data Table | Community Blog

• Then delete Col2

• Rename Col3 to Col2

[krishna_r]

page unavailable.
Can you please elaborate

[ppr (Peter Preuss)]

How to Update Data Column Values of a Data Table | Community Blog