I was looking for a way to add a cumulative total column to my GridView in vb.net that would show a cumulative total of one of the numeric columns in the row. So basically:
Points | Running Total
2 | 2
1 | 3
-0.5 | 2.5
1.5 | 4
I saw some questions on cumulative totals using SQL Server and other databases, but I found nothing about strictly using GridView without changing any SQL, so I thought I would post my solution here.
Advertisement
Answer
VB.net, something like that:
Dim val as Double = 0 For i as Integer = 0 to Me.grid.Rows.Count - 1 val += Me.grid.Rows(i).Cells("Points").Value Me.grid.Rows(i).Cells("Running Total").Value = val Next