Sum grid view column’s values & display in header of grid view.

In this article, we will learn how to find sum of column’s value. This will be very helpful in situation where we calculate marks, salary etc.
In this article we’ll calculate sum of column of dataset & display in Gridview Header.

Create Table  in Database and Enter some data to display.

Column Name	DataType
Id	Int
Component	Varchar(100)
Amount	Int
Payablebasis	Varchar(100)

Add Gridview & set Columns:

<asp:GridView ID="grdFixedWages" runat="server" AutoGenerateColumns="False" BorderStyle="Solid" DataKeyNames="Id" Font-Size="9" BorderWidth="1px" BorderColor="#000" Font-Bold="False" Width="100%" CssClass="rwd-table">

  <Columns>

                <asp:TemplateField HeaderText="Salary Components">

    <ItemTemplate>

                   <%# Eval("Component") %>

    </ItemTemplate>

                 </asp:TemplateField>

                 <asp:TemplateField HeaderText="Amount(In USD) ">

     <ItemTemplate>

                  <%# Eval("Amount") %>

     </ItemTemplate>

</asp:TemplateField>

                <asp:TemplateField HeaderText="Payable">

   <ItemTemplate>

                   <%# Eval("Payablebasis") %>

   </ItemTemplate>

                </asp:TemplateField>

 </Columns>

</asp:GridView>

Asp.net Code:

C#: Add Following Namespaces.

Using System.Data;

Using System.Data.SqlClient;

Using System.Configuration;

Create Connection:

SqlConnection con = 

new SqlConnection( ConfigurationManager.ConnectionStrings["con"].ConnectionString);

Bind grid On page load:

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            Fill_grid();

        }

    }

Bind gridview Function with database:

public void Fill_grid()

{

if (con.State == ConnectionState.Closed)

{

con.Open();

}

SqlCommand cmd = new SqlCommand("Fill_Dataset", con);

cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter adpData = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

adpData.Fill(ds);

if (ds.Tables[0].Rows.Count != 0)

{

GridView1.DataSource = ds;

GridView1.DataBind();

string Wageamount = ds.Tables[0].AsEnumerable().Sum(row => Convert.ToDouble(row.Field<string>("amount"))).ToString();

GridView1.HeaderRow.Cells[1].Text = "Amount (Total Wage: " + Wageamount.ToString() + " )";

con.Close();

}