String 0, 1234 to integer

Question

1.00/5 (1 vote)

See more:

how is it possible to convert a string 0,1234 to an integer that I can store in an SQL table that has an INT as field

What I have tried:

_sAmount = dr[13].ToString().Trim().Replace(",",".");
                    _Amount = Convert.ToInt32(_sAmount,4);

Posted 24-Oct-17 22:56pm

vdominick

Updated 24-Oct-17 23:18pm

Add a Solution

Comments

Andy Lanng 25-Oct-17 5:16am

Do you want both ints or just the non-zero?

3 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)

OriginalGriff · Answer 1 · 2017-10-24T23:18:00

Replacing the comma with a dot won't work: that doesn't create an integer - it creates a a floating point number: "0.1234" which will not parse as an integer.

You could use double.TryParse instead of Convert.ToInt32 and then cast that to an integer, but that will just give you zero, as the .1234 part will be discarded.

I'd look at my data source, and try to work out exactly what it is supposed to hold: why does your DataTable column hold numbers like "0,1234"? Is that supposed to be two comma delimited numbers? Or a single, badly separated number "01,234"? Or what? Do you even have the right column? We can;t tell, and probably you can't either!

Start with the data, and work out what you have: just trusting it and converting it blindly will give you huge problems down the line.

Andy Lanng · Answer 2 · 2017-10-24T23:17:00

Solution 1

If it's 0.1234 then an int won't be precise enough

Try double.parse(s)

Posted 24-Oct-17 23:17pm

Andy Lanng

vdominick · Answer 3 · 2017-11-13T03:43:00

Solution 3

that works but also I have numbers between

9999.9999 and -9999.9999

so negative and after the comma numbers..
how to convert that string into a sql data base.
In the database I use Numeric (10,5) witch works but how to convert them from my code c# from a string to a numeric??

dominick

Posted 13-Nov-17 3:43am