How to sum a column in repeater control

Hi Raj kumar,

Here is your solution

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





   


   

   

    
           
            <%#Eval("Salary") %>

              
           
           
               

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

               
           
       
   

   

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);

    }

}







Thanks
If this post helps you mark it as answer