Converting string to decimal type-Input string was not in a correct format.

Question

Hi Can anybody help me how to convert the value from the textbox into decimal type? I have an access database and the fields I wanted to be of type currency I changed into type decimal fixed with 2 decimals. I have this code in my C# application: com.Parameters.AddWithValue(@VkiznosbezDDVDen Convert.ToDecimal(textBox7.Text)); and I get an error: Input string was not in a correct format. Thanks in advance.

Vulpes · Answer

One thing I'd overlooked is that the Access data type is Currency. Although this is supposed to map to the .NET decimal type it might need some assistance as it only requires 8 bytes compared to decimal's 16 bytes which might explain why it's being rounded to an integer within the database. So I'd try: com.Parameters.Add(@VkiznosbezDDVDen OleDbType.Currency ).Value = dValue;

Nel · Answer

Thank you very much Vulpes. It works fine now

Nel · Answer

I tried that Vulpes but again in the database the values are inserted as integer. Nothing changed. It is very strange that on the form they appear like decimals and the calculated fields (textboxes) that take the values from the other textboxes with decimal numbers as well. But when I check them in the databse they are integer and the result is not correct.

Vulpes · Answer

Try specifying the type of the parameter explicitly: com.Parameters.Add(@VkiznosbezDDVDen OleDbType.Decimal).Value = dValue;

Nel · Answer

First thank you to both of you. But I tried that and now in the access database I get only integer not decimal values eventhough I changed the types in Number Decimal with 2 decimal places in the Access database. Could anybody help me what could be the problem please? Thank you in advance.

Jignesh Trivedi · Answer

hi I agree with above post. but kindly check your input it may be character or other than number. Also check ur database Type (i.e. it has data type decimal(53) you may enter more than this). hope this help.

Mukesh Kumar · Answer

Hi Try this decimal dvalue=0; decimal.TryParse( textBox7.Text  out dvalue); com.Parameters.AddWithValue(@VkiznosbezDDVDen dvalue );