In this blog we will know Total sum values in footer of the Repeater control.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:Repeater ID="r1" runat="server">

<ItemTemplate>

<%#Eval("Salary") %><br />

</ItemTemplate>

<FooterTemplate>

<br />

<strong>Total salary:Rs. <%#totalsal()%></strong><br />

</FooterTemplate>

</asp:Repeater>

</div>

</form>

</body>

</html>

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

SqlCommand cmd = new SqlCommand();

SqlConnection con;

string str;

protected void Page_Load(object sender, EventArgs e)

{

con = new SqlConnection(connStr);

cmd.Connection = con;

cmd.CommandText = "Select * from employee";

con.Open();

r1.DataSource = cmd.ExecuteReader();

r1.DataBind();

con.Close();

}

public string totalsal()

{

SqlConnection con = new SqlConnection(connStr);

str = "SELECT SUM(Salary) from employee";

cmd = new SqlCommand(str, con);

con.Open();

decimal Totalsalary = Convert.ToDecimal(cmd.ExecuteScalar().ToString());

con.Close();

con.Dispose();

cmd.Dispose();

return Convert.ToString(Totalsalary);

}

}