<%@ Page Inherits="my***.calcTotals" Src="20***731T0101.aspx.cs" %> CellPadding="4" CellSpacing="0" BorderStyle="Solid" BorderWidth="1" Gridlines="None" BorderColor="Black" ItemStyle-Font-Name="Verdana" ItemStyle-Font-Size="9pt" HeaderStyle-Font-Name="Verdana" HeaderStyle-Font-Size="10pt" HeaderStyle-Font-Bold="True" HeaderStyle-ForeColor="White" HeaderStyle-BackColor="Blue" FooterStyle-Font-Name="Verdana" FooterStyle-Font-Size="10pt" FooterStyle-Font-Bold="True" FooterStyle-ForeColor="White" FooterStyle-BackColor="Blue" OnItemDataBound="MyDataGrid_ItemDataBound" ShowFooter="True"> HeaderStyle-HorizontalAlign="Center" /> |
using System; using Sy***m.Web; using Sy***m.Web.UI; using Sy***m.Web.UI.WebControls; using Sy***m.Web.UI.HtmlControls; using Sy***m.Data; using Sy***m.Data.SqlClient; namespace myApp { public class calcTotals : Page { protected DataGrid MyGrid; private double runningTotal = 0; } } |
protected void Page_Load(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection("server=Localhost;database=pubs;uid=sa;pwd=;");//创建SQL连接 SqlCommand myCommand = new SqlCommand("SELECT title, price FROM Titles WHERE price > 0", myConnection);//创建SQL命令 try { my***nection.Open();//打开数据库连接 My***d.DataSource = my***mand.ExecuteReader();//指定 DataGrid 的数据源 My***d.DataBind();//绑定数据到 DataGrid my***nection.Close();//关闭数据连接 } catch(Exception ex) { //捕获错误 Ht***ontext.Current.Response.Write(ex***String()); } } |
private void CalcTotal(string _price) { try { runningTotal += Do***e.Parse(_price); } catch { //捕获错误 } } |
public void MyDataGrid_ItemDataBound(object sender, DataGridItemEventArgs e) { if (e.***m.ItemType == Li***temType.Item || e.***m.ItemType == Li***temType.AlternatingItem) { CalcTotal( e.***m.Cells[1].Text ); e.***m.Cells[1].Text = st***g.Format("{0:c}", Co***rt.ToDouble(e.***m.Cells[1].Text)); } else if(e.***m.ItemType == Li***temType.Footer ) { e.***m.Cells[0].Text="Total"; e.***m.Cells[1].Text = st***g.Format("{0:c}", runningTotal); } } |