469,643 Members | 1,233 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

C# Problem in coverting Currency Value in Number format

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\LPRS_OUTPUT\Client Interface\Test Region Wells Fargo CycleIII.TXT] - Error loading location data - System.FormatException: Input string was not in a correct format.
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.String.System.IConvertible.ToInt32(IFormatP rovider provider)
at System.Convert.ToInt32(Object value)
at System.Data.Common.Int32Storage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't store <"$182,458.00"> in MortgageValue Column. Expected type is Int32.


Thanks,
Santosh
Dec 9 '07 #1
0 1331

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by John L | last post: by
3 posts views Thread by Abby Lee | last post: by
3 posts views Thread by news.shaw.net | last post: by
14 posts views Thread by Just starting out | last post: by
11 posts views Thread by MikeY | last post: by
2 posts views Thread by crferguson | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.