Reccomended data type to use for numeric type

Question

5.00/5 (1 vote)

See more:

In my sql table I have numeric fields. When I using that in my C# back end which is the best data type to use among float, double, decimal.

Posted 11-May-11 1:24am

Sanyon_d

Add a Solution

4 solutions

Solution 1

better u can use decimal.
And u can use decimal in sql instead of numeric. There u can set how many digits after the decimal and before.

Posted 11-May-11 1:38am

abdul wahab.o

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)

Kim Togo · Accepted Answer · 2011-05-11T01:39:00

Solution 2

It depends on your needs. You can not say that this numeric fields is better than others.

Posted 11-May-11 1:39am

Kim Togo

Comments

abdul wahab.o 11-May-11 7:57am

pls check this

http://www.codeproject.com/Questions/194654/PDTHolder-couldnot-be-found.aspx

Olivier Levrey 11-May-11 8:17am

I agree. Have my 5.

Sergey Alexandrovich Kryukov 11-May-11 13:50pm

You're a man. Tell them! My 5.
--SA

Olivier Levrey · Accepted Answer · 2011-05-11T02:17:00

Kim Togo is right. The best data type makes little sense. All these types have benefits and disadvantages.

float: takes only 4 bytes. Good if you don't need high precision numbers and if you are dealing with a lot of data.
double: takes 8 bytes. Good if you need higher precision but you need more space to store them.
decimal: takes 16 bytes. Ideal for financial and monetary calculations. But don't use this type if your storage space is limited, or if you want to do intensive mathematical calculations because your CPU will spend more time with this type (use double instead).

CPallini · Accepted Answer · 2011-05-11T02:33:00

Solution 4

For mapping the SQL numeric (at least the SQL Server's one) data type you should use the .NET Decimal data type, see "Mapping CLR Parameter Data"[^] at MSDN.

Posted 11-May-11 2:33am

CPallini

Updated 11-May-11 2:35am

v2

Comments

Olivier Levrey 11-May-11 8:50am

Good point! 5+

CPallini 14-May-11 4:59am

Thank you.

Rick Shaub 11-May-11 9:50am

+5

CPallini 14-May-11 4:59am

Thanks.

abdul wahab.o 14-May-11 0:51am

+5

CPallini 14-May-11 4:59am

Thank you.

Reccomended data type to use for numeric type

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us