pass string value to type decimal

[magmo]

Hi


I have a form that holds a textfield, this textfield get its value from a sql server database, and the datatype for that specifik column is ...

Decimal
Precision: 18
Scale: 2



When I then try to update that value with the textfiled from the form, a value can for example look like this...

125,5

And when I try to insert the value in the database with this ...

MyCommand.Parameters.Add("@Price", SqlDbType.Int, 4).Value = iProductPrice


I get an error telling me.. input value is in wrong format..


Is the SqlDbType wrong or what should I change to get it to work?


Regards

 

[ca8msm]

Have you tried using SqlDbType.Decimal and casting your value to a decimal before adding it to the parameter?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[magmo]

Hi

I changed it to decimal and also added the Cdec(sString) then it worked.

Thanks for the help!


Regards

 

[chiph]

I was going to suggest using the System.Convert class.

Chip H.


____________________________________________________________________
Donate to Katrina relief:

http://s1.amazon.com/paypage/PELYGQVJ8Q7IB/103-6821258-5919825

If you want to get the best response to a question, please read FAQ222-2244 first