Which datatype should I use for those type of numbers 157838.6

Question

1.24/5 (3 votes)

See more:

hello, I have this number 157838.6, and I used many data type but nothing work when I try to insert this number in some text box bound with SQL database I have this error appear
(Input string was not in a correct format.)

What I have tried:

try float,money,decimal nothing worked

Posted 23-Aug-17 0:34am

Learn.net37

Updated 23-Aug-17 2:53am

Add a Solution

Comments

Patrice T 23-Aug-17 19:26pm

Show some code that exhibit the problem.

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.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

GKP1992 · Accepted Answer · 2017-08-23T02:42:00

Hi,

It is not very clear what might be the problem with your data. You say that you have tried float, money, and decimal but nothing works, but the value is well within the range of any of these data types, so the range is not the problem (i.e. you don't have to hit and try all the data types, float should be enough for your requirements).

The issue could be the culture of the region you belong to.
In some regions, the NumberDecimalSeparator is a ',' whereas in others it is a '.'.

What you can do is verify which one is it. For that, you can go to control panel -> Language and regions (Language on W10) -> Change date time or number formats -> Check your decimal symbol, change it if required.
For W10 Change date time or number formats -> Additional settings and you can check here.

If the format is the problem, your best bet would be validating the input from your text box before you perform any kind of operations on it.

Thanks and good luck.

itsmypassion · Accepted Answer · 2017-08-23T02:53:00

Solution 2

You can use float.TryParse method to parse the textbox value.Another option is to use NumericUpDown control or maskedtextbox instead of textbox.

Posted 23-Aug-17 2:53am

itsmypassion

Updated 23-Aug-17 16:59pm

v2

Comments

Patrice T 23-Aug-17 19:27pm

Parsing a decimal to int32, are you sure ?

itsmypassion 23-Aug-17 22:59pm

Its float.tryparse