Totaling a column in Datgrid

[Atif Jalal]

Hi,
I would like to know if there is a way to print 'Sum' of all the
values of one of the columns in a datagrid in an ASP.net application
using vb.net. The Sum should be displayed all the way at the end below
the column values.

Like:
___________________________
Column1 Column2 Column3
___________________________
XX
YY
ZZ

 

[Daniel Bass]

one way to do this would be to forget the datagrid, but rather look at the
source...
if the source is a table, for example, you could easily enumerate through
the rows at that column, and tally up the value, then create a new row which
has a column for that total.
if the source isn't a table, convert it to one and make the table the data
source.

hope that helps.
Dan.

Hi,
I would like to know if there is a way to print 'Sum' of all the
values of one of the columns in a datagrid in an ASP.net application
using vb.net. The Sum should be displayed all the way at the end below
the column values.

Like:
___________________________
Column1 Column2 Column3
___________________________
XX
YY
ZZ

 

[Alvin Bruney]

One approach is to insert the subtotal into the footer row of the datagrid
in the itemdatabound routine.

if(e.itemtype == listitemtype.footer)
string strCol = columname;
e.item.cells[0].Columnspan = 2;
e.item.cells[0].Text = "Sum";
e.item.cells[0].BackColor= Color.LimeGreen;
e.item.cells[1].Text =
ds.Tables[0].Compute("Sum(["+strCol+"])",String.Empty));