Arithmetic Operation Overflow Error in Linq Query

Hi All, i am using a linq query to add 1 to a phone number if “analyst” is there in column and if it isnt adding 0 to the phone number column, but its giving me arithmetic operation overflow error

Query-
image

Sheet-

Kindly help
Thanks!

@supermanPunch @Anil_G @ppr @Yoichi

Go for
Clng(… instead of CInt or use an Int64

It looks like the Phone no exceeds the max Int32 value

image
@ppr

we already told:

so change as mentioned

@ppr i used Clng above error is after that only

@ppr
image

we hope that you have realized that also the datatype for this col in dt_Output cannot be an Int32 and maybe needs to be remodelled e.g. Int64

@ppr

Can you please let me know how to remodel a specific column in datatable

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.