How to display values only upto 2 decimal places

Question

I have a table column "Amount" of type money. When I am retrieving its value through a store procedure, it returns the value upto 4 decimal places(because of type money). I want the value upto two decimal places and I want it to handle in the code. How will I do it by rounding off the value to 2 decimal place. Thanks

Answer 1

Read Custom Numeric Formats for detailed instructions on formatting numbers.

value.ToString("0.00");

In C# 6 or later, you can use string interpolation for a somewhat cleaner syntax.

$"{value:0.00}";