Author: stretcher25 | Posted on: 11/9/2009 5:09:45 AM | Views : 439

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 ...