Totals in grid footer?

[SStory]

Is there a way to show subtotals in the footer of a datagrid?

How?

Thanks,

Shane

 

[Scott Mitchell [MVP]]

Is there a way to show subtotals in the footer of a datagrid?

How?

Essentially you need to keep a running total, updating the running total
in the ItemDataBound event handler for each Item or AlternatingItem.
For the Footer, you need to programmatically insert this running total
value.

There's an article here that shows how to accomplish this and more:
http://aspnet.4guysfromrolla.com/articles/073003-1.aspx

Happy Programming!

--

Scott Mitchell
(e-mail address removed)
http://www.4GuysFromRolla.com
http://www.ASPFAQs.com
http://www.ASPMessageboard.com

* When you think ASP, think 4GuysFromRolla.com!

 

[SoftLion]

Or simply you can add a Table to your DataSet (it supports more than one
table/=result set/=query returned all in only one database roundtrip !) with
totals in it and modify the FooterItemTemplate of each item to display the
content of this second table.
This way you'll get the total correct even if pagination is turned on.

4GuysFromRolla rocks, thanks to you for your excellent datagrid's articles !
It's the best jump start I've found. Though you could improve the handling
of drop-downs (static) content by using the same technique as above.
What is missing is how to get a good user feeling when editing in a datagrid
: simulate smartnavigation while editing (add/delete/modify) the grid
content.

Benjamin.

 

[Saravana [MVP]]

Check out this article,
http://www.extremeexperts.com/Net/Articles/AddingControlstoFooter.aspx