HI, Looks like it also works good as expected when I changed the If statement to include 'Or e.Item.ItemType = ListItemType.EditItem' at the end. So I am good with the Sum/Total now. But when I change the Cell I would like the Total/Sum also be changed. Any help appreciated.
Thanks, -L On Feb 10, 9:40 am, Learner <[email protected]> wrote: > Hi, > > I am summing a column in my DataGrid and displaying total at the > footer with the below piece of code > > If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = > ListItemType.AlternatingItem Then > 'Snip out the ViewCount > Dim ContributionWithHeld As Integer = > Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, > "ContributionWithHeld")) > myTotalContributionWithHeld += > ContributionWithHeld > ElseIf e.Item.ItemType = ListItemType.Footer Then > e.Item.Cells(20).Text = "Total: " & String.Format > ("{0:#,###}", myTotalContributionWithHeld) > End If > > and it works great and it dispaly the correct total when it binds the > data. But if I click on Edit row button in the grid then the Sum/Total > at the footer changes (deducts the value of that cell in that row from > the total). Looks like the the row that is in Edit mode is not being > taken into acount while summing the values. > > Can some one help me with this how to change the above code or what I > else I need to do to display the Sum correct even if any of the rows > in Edit mode. > > Also, the other thing I would like to be able to do is when a row in > Edit mode and as I change the value in the Cell that I would like > Sum , the Sum at the footer needs to be changed. May be I need to do > it under OnCellChange event but not sure where and how do I do it as I > never done this before. > > Please help. > > Thanks, > > -L
