The current sub procedure (written in asp.net 1.1 / vb2003) outputs the value as :
Total : 12
I want to set this up as :
Total : £12:00.
Code:
The source access database has the values set to currency with two decimal
places. How do I achieve this ? Here's the source code :
Sub ComputeSum(sender As Object, e As DataGridItemEventArgs)
'Ensure dealing with an Item or AlternatingItem
If e.Item.ItemType = ListItemType.Item OR _
e.Item.ItemType = ListItemType.AlternatingItem then
'Define the ViewCount
Dim viewCount as Integer = _
Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "curSalePrice"))
viewCountSum += viewCount
ElseIf e.Item.ItemType = ListItemType.Footer then
e.Item.Cells(7).Text = "Total: £" & String.Format("{0:#,###}",
GetTotal())
End If
End Sub