Hi,
I want to display Totals in a DataGrid. But the total doesn't change when AllowPaging is set to true. The total displayed for all the pages is the one that is displayed on the first page.
The Code Behind is:
* * * * * *
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace Practice
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private double runningTotal = 0;
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection con=new SqlConnection ();
con.ConnectionString="Server=localhost;uid=sa;pwd= sa;Database=Northwind;";
con.Open();
SqlDataAdapter dap=new SqlDataAdapter("select ProductName, UnitPrice from Products",con);
DataSet dst= new DataSet();
dap.Fill(dst);
DataGrid1.DataSource=dst.Tables[0];
DataGrid1.DataBind();
con.Close();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHand ler(this.DataGrid1_ItemCommand);
this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler (this.DataGrid1_ItemDataBound);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void CalcTotal(string _price)
{
try
{
runningTotal += Double.Parse(_price);
}
catch
{
//A value was null
}
}
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
CalcTotal( e.Item.Cells[2].Text );
e.Item.Cells[2].Text = string.Format("{0:c}", Convert.ToDouble(e.Item.Cells[2].Text));
}
else if(e.Item.ItemType == ListItemType.Footer )
{
e.Item.Cells[0].Text="Total";
e.Item.Cells[1].Text = string.Format("{0:c}", runningTotal);
}
}
//*Select a Row in DataGrid
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if( e.CommandName.ToUpper() == "SELECT")
{ // "Command edit" column clicked.
// (Column with SELECT command selected.)
// Fetch customer number out of zeroth bound column.
Label1.Text =e.Item.Cells[1].Text;
// Redirect to update page.
//Response.Redirect( "WebForm2.aspx" );
}
}
}
}
* * * * * *
The HTML code is"
* * * * * *
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="Practice.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 23px; POSITION: absolute; TOP: 44px" runat="server"
Width="275px" Height="249px" BorderColor="#DEBA84" BorderStyle="None" CellSpacing="2" BorderWidth="1px"
BackColor="#DEBA84" CellPadding="3" AllowPaging="True" ShowFooter="True">
<SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#738A9C"></SelectedItemStyle>
<ItemStyle ForeColor="#8C4510" BackColor="#FFF7E7"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#A55129"></HeaderStyle>
<FooterStyle ForeColor="#8C4510" BackColor="#F7DFB5"></FooterStyle>
<Columns>
<asp:ButtonColumn Text="Click" HeaderText="Column" CommandName="SELECT"></asp:ButtonColumn>
</Columns>
<PagerStyle HorizontalAlign="Center" ForeColor="#8C4510" Mode="NumericPages"></PagerStyle>
</asp:DataGrid>
<asp:Label id="Label1" style="Z-INDEX: 103; LEFT: 30px; POSITION: absolute; TOP: 12px" runat="server"
Width="266px" BackColor="#FFC080">Label</asp:Label>
</form>
</body>
</HTML>
* * * * * *
The Totals Field doesn't change with Paging.
