Why asp.net C# Decimal type doesn't get cents?

Asked Jan 11 '18 at 00:14

Active Jan 11 '18 at 00:14

Viewed 33 times

I have a MySQL database with a column Amount type Decimal(10,2). I use LINQ to insert a record into the database.

myTable table = new myTable();
int intAmount = 106564; // I received the data in this format. It is $1,065.64
myTable.Amount = (intAmount / 100); // Why it sets the value to 1065 instead of 1065.64?

Does C# Decimal doesn't support decimal values?!?

asked Jan 11 '18 at 00:14

Max Boy

1

Both numbers are integers and thus integer arithmetic is applied. Use `(intAmount / 100.0M)`; – Gusman Jan 11 '18 at 00:15
Still same problem using 100.0M – Max Boy Jan 11 '18 at 00:18
I believe it is not duplicated because my issue is with Decimal, not float – Max Boy Jan 11 '18 at 00:21
It's the same issue, decimal or float doesn't matter. – DavidG Jan 11 '18 at 00:23
What is the datatype of `myTable.Amount`? The solution of using 100.0઼M should work. https://dotnetfiddle.net/EaULRr – Chetan Jan 11 '18 at 00:30

Why asp.net C# Decimal type doesn't get cents?

0 Answers0