Hello,
I have written a Console application in C#, it basically imports data from tab delimited text files and save in SQl Server database. I am converting currency format of Mortgage value into Number format and saving in database. All works fine at my local machine but when I deployed the .Exe file in test environment I am getting below error message ... Couldn't store <"$182,458.00 "> in MortgageValue Column.
Can any one help me out how to resolve this ?
Error Loading Data for [\\davap0001\LPR S_OUTPUT\Client Interface\Test Region Wells Fargo CycleIII.TXT] - Error loading location data - System.FormatEx ception: Input string was not in a correct format.
at System.Number.P arseInt32(Strin g s, NumberStyles style, NumberFormatInf o info)
at System.String.S ystem.IConverti ble.ToInt32(IFo rmatProvider provider)
at System.Convert. ToInt32(Object value)
at System.Data.Com mon.Int32Storag e.Set(Int32 record, Object value)
at System.Data.Dat aColumn.set_Ite m(Int32 record, Object value)Couldn't store <"$182,458.00 "> in MortgageValue Column. Expected type is Int32.
Thanks,
Santosh
I have written a Console application in C#, it basically imports data from tab delimited text files and save in SQl Server database. I am converting currency format of Mortgage value into Number format and saving in database. All works fine at my local machine but when I deployed the .Exe file in test environment I am getting below error message ... Couldn't store <"$182,458.00 "> in MortgageValue Column.
Can any one help me out how to resolve this ?
Error Loading Data for [\\davap0001\LPR S_OUTPUT\Client Interface\Test Region Wells Fargo CycleIII.TXT] - Error loading location data - System.FormatEx ception: Input string was not in a correct format.
at System.Number.P arseInt32(Strin g s, NumberStyles style, NumberFormatInf o info)
at System.String.S ystem.IConverti ble.ToInt32(IFo rmatProvider provider)
at System.Convert. ToInt32(Object value)
at System.Data.Com mon.Int32Storag e.Set(Int32 record, Object value)
at System.Data.Dat aColumn.set_Ite m(Int32 record, Object value)Couldn't store <"$182,458.00 "> in MortgageValue Column. Expected type is Int32.
Thanks,
Santosh