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-

Sheet-
Kindly help
Thanks!
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-

Sheet-
Kindly help
Thanks!
Go for
Clng(… instead of CInt or use an Int64
It looks like the Phone no exceeds the max Int32 value
we already told:
so change as mentioned
@ppr i used Clng above error is after that only
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
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.