The value is not valid for double/decimal

Question

Hello, I've been trying to get this to work for ages now and I've ran out of options. No matter what I try, the value for a double/decimal is always invalid according to the Jquery validator. This is a list of what I tried:

Set culture in web.config
Set culture in CurrentThread
Change type from Decimal to Double
Change input type from Number to Text
Use globalize.js
Use a custom regex fix found on here
Use a DecimalBinder found on here

Nothing, absolutely nothing fixes this error. I'd greatly appreciate if somebody could point out what I was doing wrong here.

It looks like you gave comma (,) in 55,95. Was that expected? — Ashokan Sivapragasam, Dec 24 '18 at 11:14
The number input automatically changes it to a comma, eventhough in the validation it says a dot (.) — RayShawnOfNapalm, Dec 24 '18 at 11:22
Please NEVER use a picture in place of posting the actual code. It breaks the search index and nobody can cut and paste. — Sparky, Dec 24 '18 at 15:45

score 1 · Answer 1 · answered Dec 24 '18 at 21:41

DisplayFormat.DataFormatString uses .NET's predefined formatting rules. In particular, the . (dot/period) is always interpreted to mean "the decimal point of the current culture", which in your case is ,, or comma.

If you want a literal dot separating the whole and fractional parts of the number, you need to escape it:

[DisplayFormat(DataFormatString = @"{0:0\.00}", ApplyFormatInEditMode = true)]

The value is not valid for double/decimal

1 Answers1