How to assign the total value of a column to the footer?

[TeiUKei]

Dear all, I was doing a calculation on the total of costs using datagrid. There are only two row in my data. I use the following to insert the summary to the footer but is not success which is as below: For RawCount = 0 To ItemCount - 1 Quantity(RawCount) = Me.dtGrid.Items(RawCount).Cells(2).Text Price(RawCount) = Me.dtGrid.Items(RawCount).Cells(5).Text Costs(RawCount) = Quantity(RawCount) * Price(RawCount) Me.dtGrid.Items(RawCount).Cells(6).Text = Costs(RawCount) TotalQuantity = Quantity(RawCount) + TotalQuantity TotalCost = TotalCost + Costs(RawCount) If Me.dtGrid.Items(RawCount).ItemType = ListItemType.Footer Then Me.dtGrid.Items(RawCount).Cells(2).Text = TotalQuantity End If Could anyone please help me check what is the problem and why the data is not display in my footer raw? Thank you so much for the help!

[Gaurav Dudeja India]

Please refer from Here[^]