SumColumn: Custom DataGrid Column that automatically shows Sum/Count/Average in DataGrid Footer.

A normal requirement in any ASP.Net application is to sum/average up the values in a DataGrid column to the Footer. In this article we will compare the normal methods and later create our own custom DataGrid column SumColumn, derived from BoundColumn to avoid repetition of the same code.

Syed Aziz ur Rahman

Feb 20, 2006 · Updated Apr 13, 200951.4k50100Article

The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: SumColumn: Custom DataGrid Column that automatically shows Sum/Count/Average in DataGrid Footer.

.NET VB.NET DataGrid DataTable Data Source Exception Class Library DataBindDesign TimeSystem.WebComputeDataFieldWeb Form ControlsCreating Custom Datagrid ColumnCustom DataGrid ColumnData Grid AverageData Grid Countquery databaseDataGrid FooterDataGrid Sum

5 Comments

Join the conversation! Your thoughts help the community grow.

Steve17y ago
I did something mildly similar before. Rather than write ASP.Net code to summarize data, I used T-SQL and temporary tables. One grid that represents the detail of the data, a second one that summarizes, in this case money, values such as Month-To-Date and Year-To-Date. Both are temporary tables returned by the stored procedure but who's life-span is the execution of the procedure. It's quick and clean, and all the logic and work is back-ended to the server. The ASP.Net code is just a few lines, amounting to assigning the result set from the procedure to the grid.
- Syed Aziz ur Rahman17y ago
  Hi, You are right and there are several other methods to perform the task done in the artcile. But you missed the point. My focus was just to do some kind of datagrid related task encapsulated inside a custom column so that it can be reuse in every other applications. The task can range from formatting to other repeated complex operations in a particular application. I hope i cleared the point.
shafaqat ali17y ago
System.Web.UI.WebControls.DataControlFieldCollection must have items of type 'System.Web.UI.WebControls.DataControlField'. 'Custom:CustomColumn' is of type 'Custom.CustomColumn'. "Custom"=My ClassLibraryName "CustomClass"= my class name
Jorge Salinas17y ago
Very useful, i'm using this right away.
rama kishore20y agoedited
It is very useful application. while way of telling the application is also very good. my email is [email protected] Regards, ramakishore. [edit]