How to convert textbox value to decimal(4,4)

Question

0.00/5 (No votes)

See more:

I am facing problem to store a value in database of type Decimal(4,4). On entering the value in txtbox it throws an exception 'Error converting data type numeric to decimal.'
Please help me for solution

Posted 22-Nov-11 20:18pm

waqar ahmad (Dev)

Add a Solution

Comments

rajeevcapgeminiindia 23-Nov-11 3:32am

I think it is not possible like decimal(4,4) because before decimal no value is there.

2 solutions

Solution 2

Use Round function, in this when third parameter is not 0, then it truncates rather than rounds

SQL

ROUND ( 123.456 , 2 , 1 )

Further you can refer
http://msdn.microsoft.com/en-us/library/ms175003(SQL.90).aspx[^]

Posted 29-Nov-11 0:44am

Anuja Pawar Indore

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)

Anuja Pawar Indore · Accepted Answer · 2011-11-22T21:15:00

Solution 1

Decimal (4,4) means total length is 4, out of which 4 are reserved for decimal. Then nothing will be before decimal.

Ex Decimal(10,8) means total length 10 out of which 8 before decimal and 2 after decimal.

So increase the length of your field in database

Posted 22-Nov-11 21:15pm

Anuja Pawar Indore

Comments

waqar ahmad (Dev) 29-Nov-11 5:40am

I fix my problem from your reply. I set decimal(8,4) for decimal value 4,4. Now when these values saved, are automatically round off e.g when I enter value 2.369 it will convert automatically 2.3700. I want to prevent it for automatically conversion.
Hope you have solution of my problem

RaisKazi 29-Nov-11 6:50am

My 5.

Anuja Pawar Indore 29-Nov-11 6:55am

Thanks RaisKazi