How to count the column values of the DataGrid and display them in the footer

Source: Internet
Author: User

As we all know, javasird is a powerful data binding control, which is easy to use and has advantages and disadvantages. I believe everyone knows its interests. Here we will not go into the topic.
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 lblQuantity.

Third, write the following code in the ItemDataBound event of DG:

If (e. Item. ItemIndex> = 0)
{
// Retrieve the total data of the specified Column
Label lblQuantity = (Label) e. Item. Cells [5]. FindControl ("lblQuantity"); // For example, the sixth column is the number.

IntSum + = int. Parse (lblQuantity. Text. ToString ());
}
Else if (e. Item. ItemType = ListItemType. Footer)
{
E. Item. Cells [2]. Text = "<font color = 'red'> total: </font>"; // The total is displayed in the third column.
E. item. cells [5]. text = "<font color = 'red'>" + intSum. toString () + "</font>"; // The number of statistics displayed in column 6 can be adjusted as required.
}

Note: intSum is a global variable. The test code runs normally under VS2003.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.