I reviewed a couple of tutorials that show how to display totals in
the footer of a gridview. My footer shows up blank. Can someone help
me. The code is as follows:
<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<script runat="server">
Dim weighttotal As Decimal = 0
'Dim quantityTotal As Integer = 0
Sub detailsGridView _RowDataBound(B yVal sender As Object, _
ByVal e As GridViewRowEven tArgs)
If e.Row.RowType = DataControlRowT ype.DataRow Then
' add the UnitPrice and QuantityTotal to the running total
variables
weighttotal +=
Convert.ToDecim al(DataBinder.E val(e.Row.DataI tem, _
"scale1"))
ElseIf e.Row.RowType = DataControlRowT ype.Footer Then
e.Row.Cells(1). Text = "Totals:"
e.Row.Cells(2). Text = weighttotal.ToS tring()
e.Row.Cells(1). HorizontalAlign = HorizontalAlign .Right
e.Row.Cells(2). HorizontalAlign = HorizontalAlign .Right
e.Row.Font.Bold = True
End If
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitl ed Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server"
AutoGenerateCol umns="False" DataKeyNames="I D"
showfooter=true
DataSourceID="A ccessDataSource 1" Style="z-index: 100;
left: 88px; position: absolute;
top: 115px">
<Columns>
<asp:BoundFie ld DataField="ID" HeaderText="ID"
InsertVisible=" False" ReadOnly="True"
SortExpression= "ID" />
<asp:BoundFie ld DataField="Scal e1" HeaderText="Sca le1"
SortExpression= "Scale1" />
<asp:BoundFie ld DataField="Scal e2" HeaderText="Sca le2"
SortExpression= "Scale2" />
<asp:BoundFie ld DataField="Empl oyee"
HeaderText="Emp loyee" SortExpression= "Employee" />
</Columns>
</asp:GridView>
<asp:AccessData Source ID="AccessDataS ource1" runat="server"
DataFile="~/App_Data/Spare_Parts_II_ BCPC.mdb"
SelectCommand=" SELECT * FROM [Scrap]"></
asp:AccessDataS ource>
</div>
</form>
</body>
</html>
