Count the column values of the DataGrid and display them in the footer.

First, you must allow the footer of the DG to be displayed. (Used to display the statistical column value)
Second, set the columns to be counted as template columns, edit the item template in the template column, and name the label control in the item template as lblmngmon.
Third, declare the global variable sum.
Third, write the following in the itemdatabound event of DG: Code:

If (E. Item. itemindex> = 0)
{
// Retrieve the total data of the specified Column
Label lblmngmon = (Label) E. Item. cells [3]. findcontrol ("lblmngmon"); // For example, column 4th as the amount
Sum + = convert. todouble (lblmngmon. Text. tostring ());
}
Else if (E. Item. itemtype = listitemtype. footer)
{
E. Item. cells [0]. Text = "<font color = 'red'> total: </font> ";
E. item. cells [3]. TEXT = "<font color = 'red'>" + String. format ("{0: c}", sum) + "</font> ";

// The fourth column shows the statistical amount.
}