In this article we will know how to find total sum of values present in database into a Gridview.The total sum will be appeared in the footer of the gridview. Remember in gridview add ShowFooter="True".Add a TemplateField within this field add FooterTemplate.

Table structure

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">

<title>Total Count</title>

</head>

<body>

<div>

<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" />

<asp:TemplateField>

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

</FooterTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

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

bind()

End Sub

Sub bind()

Dim con As New SqlConnection(strConnString)

con.Open()

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"

GridView1.DataBind()

con.Close()

End Sub

Function totalsal() As String

Dim con As New SqlConnection(strConnString)

str = "SELECT SUM(salary) from employee"

com = New SqlCommand(str, con)

con.Open()

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

con.Close()

con.Dispose()

com.Dispose()

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

bind()

End Sub

End Class

Output

Total sum values in footer of gridview in VB.NET

Table structure

Default.aspx code

Output

Thanks for reading