How to format a decimal without trailing zeros
There are several ways to do it, but since you are converting to a String object anyway, I suppose you could try something like this:
myDecimalVariable.ToString("G29");
or, using your code above, assuming 123.00M
is your decimal:
123.00M.ToString("G29");
Here is the explanation of how that concise example works:
The G format with a number means to format that many significant digits. Because 29 is the most significant digits that a Decimal can have, this will effectively truncate the trailing zeros without rounding.