TextBox Convert it to Decimal? ....Help!!

Question

Hi, 

I have a textbox aka TXT_Weighting in which I place a value of %. 

If I put in a number   0 < number < 100, it works. 

However, If I put in 100, I get this error: "error converting Data Type numeric to decimal"

The Database Field has the DataType of decimal(10,2).

I have tried converting it to decimal, string, int, float in the application, but once it saves, gives the same error. 

I know it is because of the database field having the type as decimal. But I cant stop the entire application, just so I can change the data type of the field. 

How do I save it without getting this error? How do I control it from the application? 

Regards,

Shav

Edit: 

Initially, it was this: 

.Parameters("@weighting").Value = Val(Me.Txt_Weighting.Text)

I tried this, doesn't work. 

.Parameters("@weighting").Value = Convert.ToDecimal(Txt_Weighting.Text)

Answer 1

Convert.ToDecimal should work. Here it does:

      Dim dec As Decimal

      dec = Convert.ToDecimal("100")

So, the conversion itself is not the problem. 

EDIT: Forget what I wrote below as 2 is the number of decimal places. 

As the number 100 has 3 decimal places, there's an error if you specified a precision of only 2.


(Good to not use the Val function. It's ancient and not compatible to the rest of the .Net Framework's parsing/formatting handling.)

---

Armin

Answer 2

You wrote the type in the database is decimal (10,2), but what's the type of the @weighting parameter?

---

Armin

Answer 3

As follows: 

 .Parameters.Add("@weighting", SqlDbType.Decimal) 

Answer 4

Doesn't the 2 indicate the number of decimal places after the decimal point? 

I mean 100.00

Answer 5

Doesn't the 2 indicate the number of decimal places after the decimal point? 

I mean 100.00

Yes, that's right. That's why I wrote in bold that you should ignore that answer of mine. You were probably quicker. :-)

I'm afraid, currently I don't know why it does not work.

---

Armin

Answer 6

Hi Armin, 

I resolved it. I overlooked the Stored Procedure, The stored procedure had the value as decimal(4,2). 

Updated it, works like a charm. Our code was totally okay. 

Thanks for your time buddy. 

Shav

Answer 7

Shanks, it's nice of you to mark my message as the answer, but I think it isn't. :-) Shavendra found the solution on his own in his last message.

---

Armin