How do I make summary rows using the datagrid?.
Scenario:
Grid currenlty displays inventory items. I would like to provide quantity on hand totals, by inventory location, at the end (footer)of the grid listing regardless of how the grid is sorted.
The number of locations is variable.
As in:
Loc 1 QOH = sum(QOH of Loc 1 rows)
Loc 2 QOH = sum(QOH of Loc 2 rows)
Loc 3 QOH = sum(QOH of Loc 3 rows)
===============
Total QOH = sum(QOH column)
QOH = Quantity On Hand
Using VB.NET Windows Form.
Not using datareaders
Using COM to get data
Datagrid is read only
Any and all suggestions are welcome.
tia,
Todd