January 2013 ~ Ajay Agrahari

Introduction:

In this article I will explain how to display the sum of total of columns in gridview footer using asp.net.

Description:

I have a one gridview with multiple rows and columns and for that gridview paging also has enabled now my requirement I need to display sum of all the columns (Total) in gridview footer for that I have used gridview row databound condition this functionality will work for paging enabled gridview also. Before proceed to functionality first we need to design one table in database and give nameEmployeeSalary

Column Name	Data Type
EmpID	Int (set identity property=true)
EmpName	varchar(50)
Location	varchar(50)
Amount	varchar(50)

After completion table creation enter some dummy and design your aspx page like this

<title>Show gridview Rows Total in </title>

.Gridview

{

font-family:Verdana;

font-size:10pt;

font-weight:normal;

color:black;

}

</style>

</head>

<body>

<div>

<asp:GridView ID="gvEmp" CssClass="Gridview" HeaderStyle-BackColor="#61A6F8"

HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold ="true" DataKeyNames="EmpID"

runat="server"ShowFooter="true" AllowPaging="true" PageSize="5"
AutoGenerateColumns="false" DataSourceID="sqldsEmp"
onrowdatabound="gvEmp_RowDataBound">

<asp:BoundField DataField="EmpID" HeaderText="Emp ID" />

<asp:BoundField DataField="EmpName" HeaderText="Emp Name" />

<asp:TemplateField HeaderText="Location">

<asp:Label ID="lblLocation" runat="server" Text='<%#Eval("Location") %>'/>

</ItemTemplate>

<asp:Label ID="lbltxttotal" runat="server" Text="Total Amount"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Amount">

<asp:Label ID="lblamount" runat="server" Text='<%# Eval("Amount") %>'/>

</ItemTemplate>

<asp:Label ID="lblTotal" runat="server" />

</FooterTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="sqldsEmp" runat="server"
SelectCommand="select * from EmployeeSalary"
ConnectionString="<%$ ConnectionStrings:dbconnection %>">

</asp:SqlDataSource>

</div>

</form>

</body>

</html>

After completion of aspx page write the following code in codebehind

int total = 0;

protected void gvEmp_RowDataBound(object sender, GridViewRowEventArgs e)

{

if(e.Row.RowType==DataControlRowType.DataRow)

{

total += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "Amount"));

}

if(e.Row.RowType==DataControlRowType.Footer)

{

Label lblamount = (Label)e.Row.FindControl("lblTotal");

lblamount.Text = total.ToString();

}

After that set your database connection in web.config like this because we are using this connection in our sqldatasource to get the data from database