.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Imran Ghani

Home >> Code Snippets >> ASP.NET Controls >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Total sum values in footer of gridview

Posted By:satyapriyanayak       Posted Date: March 25, 2013    Points: 40    Category: ASP.NET Controls    URL: http://www.dotnetspark.com  

Total sum values in footer of gridview

Default.aspx code



<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" 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>Total Count</title>



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


    <asp:GridView ID="GridView1" runat="server"  DataKeyNames="empname" AllowPaging="true" PageSize="10"

  AutoGenerateColumns="False" CellPadding="4"

  GridLines="None" ShowFooter="True">


  <asp:BoundField DataField="empname" HeaderText="Name" />

  <asp:BoundField DataField="salary" HeaderText="Salary" />



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





  <RowStyle BackColor="#ffffcc" ForeColor="Red" />

  <FooterStyle BackColor="#ccffcc" Font-Bold="True" ForeColor="#cc3300" />

  <HeaderStyle BackColor="Aqua" Font-Bold="True" ForeColor="#993300" />








Default.aspx.vb code


Imports System.Data

Imports System.Data.SqlClient

Imports System.Configuration

Partial Class _Default

    Inherits System.Web.UI.Page

    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()

    Dim str As String

    Dim com As SqlCommand

    Dim sqlda As SqlDataAdapter

    Dim ds As DataSet

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load


    End Sub

    Sub bind()

        Dim con As New SqlConnection(strConnString)


        str = "select * from employee"

        com = New SqlCommand(str, con)

        sqlda = New SqlDataAdapter(str, con)

        ds = New DataSet

        sqlda.Fill(ds, "employee")

        GridView1.DataSource = ds

        GridView1.DataMember = "employee"




    End Sub

    Function totalsal() As String

        Dim con As New SqlConnection(strConnString)

        str = "SELECT SUM(salary) from employee"

        com = New SqlCommand(str, con)


        Dim Totalsalary As Decimal = Convert.ToDecimal(com.ExecuteScalar())




        Return String.Format(Totalsalary)

    End Function


    Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging

        GridView1.PageIndex = e.NewPageIndex


    End Sub

End Class