string to double

Question

5.00/5 (1 vote)

See more:

I created an application in vb.net 2005. It works fine on my machine. I tested several different test machines and all were working fine. As for the client, it's generating an error. My application reads from an excel sheet and imports the values to an oracle database. the error being generated is: "conversion from type string to type double is not valid". Why is it generating on on the client's computer and not mine?

Posted 13-Aug-09 0:06am

dandalero

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

Luc Pattyn · Answer 1 · 2009-08-13T00:23:00

Hi,

if an app runs fine on one machine and not on the other, it is because there is at least one bug in the app; it could be something was looked over, in your case maybe the system (or Excel itself) was used with different regional settings, resulting in a different character choice for "decimal point" and "group separator" (or "thousands separator").

For apps that need to work together, you have to impose similar working conditions; so either they all should follow a fixed standard, or they all should obey the regional settings, or they all should be configurable and get the same configuration settings.

:)

Moreno Airoldi · Answer 2 · 2009-08-13T00:42:00

It's most likely a problem with Culture settings. On the two PCs you probably have different characters as decimal separators.

Have a look at CultureInfo[^], it provides an InvariantCulture[^] property that lets you build culture-insensitive apps, as well as several properties which expose the host machine's culture settings.

string to double

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0