I have an access database I'm accessing using oledb in C#. I have two fields (quantity and unit price) that I am multiplying to display in a datagrid as "total." The problem is that when the total ends up being a number like $3.20, it gets displayed as 3.2
So, how can I make sure that there are always 2 digits after the decimal point? Does the answer lie in the sql itself, or is there c# code that will do this?