I have a currency total in the footer of my DataGrid that is rounding. Only the numbers to the right of the decimal are always .00, so I guess it's not rounding and just not using these numbers to the right of the decimal. So if I have $1,324.52 for the total it displays as $1,324.00
My fields in the SQL database are set to money. The data is correct in the database.
Here is my code to generate the total:
Sub dgCustomer_ItemDataBound(ByVal sender As Object, ByVal e As DataGridItemEventArgs)
'First, make sure we are dealing with an Item or AlternatingItem
If e.Item.ItemType = ListItemType.Item Or _
e.Item.ItemType = ListItemType.AlternatingItem Then
'Snip out the ViewCount
Dim viewCount As Double = DataBinder.Eval(e.Item.DataItem, "SubTotal","{0:c}")
viewCountSum += viewCount
ElseIf e.Item.Ite ...
Go to the complete details ...