DataGrid 完全攻略之四 （实现统计）

前台代码：html

<% @ Page language="c#" Codebehind="UserCount.aspx.cs" AutoEventWireup="false" Inherits="MsDataGrid.UserCount"  %>
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"  >
< HTML >
     < HEAD >
         < title > DataGrid使用举例 </ title >
         < meta  name ="GENERATOR"  Content ="Microsoft Visual Studio 7.0" >
         < 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" >
             < FONT  face ="宋体" >
                 < asp:DataGrid  id ="dgShow"  style ="Z-INDEX: 101; LEFT: 31px; POSITION: absolute; TOP: 93px"  runat ="server"  Width ="842px"  Height ="172px"  BorderColor ="Tan"  BorderWidth ="1px"  BackColor ="LightGoldenrodYellow"  CellPadding ="2"  GridLines ="None"  ForeColor ="Black"  PageSize ="1"  AutoGenerateColumns ="False"  ShowFooter ="True" >
                     < SelectedItemStyle  ForeColor ="GhostWhite"  BackColor ="DarkSlateBlue" ></ SelectedItemStyle >
                     < AlternatingItemStyle  BackColor ="PaleGoldenrod" ></ AlternatingItemStyle >
                     < HeaderStyle  Font-Bold ="True"  BackColor ="Tan" ></ HeaderStyle >
                     < FooterStyle  BackColor ="Tan" ></ FooterStyle >
                     < Columns >
                         < asp:BoundColumn  DataField ="StudentID"  ReadOnly ="True"  HeaderText ="学生ID" ></ asp:BoundColumn >
                         < asp:BoundColumn  DataField ="StudentName"  HeaderText ="学生姓名" ></ asp:BoundColumn >
                         < asp:BoundColumn  DataField ="StudentPass"  HeaderText ="密码" ></ asp:BoundColumn >
                         < asp:BoundColumn  DataField ="Sex"  HeaderText ="性别" ></ asp:BoundColumn >
                         < asp:BoundColumn  DataField ="Birthday"  HeaderText ="生日"  DataFormatString ="{0:yyyy-M-d}" ></ asp:BoundColumn >
                         < asp:BoundColumn  DataField ="Email"  HeaderText ="邮件地址" ></ asp:BoundColumn >
                         < asp:BoundColumn  DataField ="Score"  HeaderText ="分数" ></ asp:BoundColumn >
                     </ Columns >
                     < PagerStyle  HorizontalAlign ="Center"  ForeColor ="DarkSlateBlue"  BackColor ="PaleGoldenrod" ></ PagerStyle >
                 </ asp:DataGrid ></ FONT >
         </ form >
     </ body >
</ HTML >

后台代码：cs

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  MsDataGrid
{
    /// <summary>
    /// WebForm1 的摘要说明。
    /// </summary>
    public class UserCount : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.DataGrid dgShow;
    
        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            if(!IsPostBack)
                BindData();
            
            
        }
        private void BindData()
        {
            string strCon = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
            SqlConnection con = new SqlConnection(strCon);
            SqlDataAdapter da = new SqlDataAdapter("Select * from tbStudentinfo",con);
            DataSet ds = new DataSet();
            da.Fill(ds,"studentinfo");
            dgShow.DataSource = ds.Tables["studentinfo"].DefaultView;
            dgShow.DataBind();
            //以下作分数和的统计
            int count=0;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                count += int.Parse(ds.Tables[0].Rows[i]["Score"].ToString());
            }
            int nAv = count/ds.Tables[0].Rows.Count;
            foreach(DataGridItem dgi in dgShow.Controls[0].Controls)
            {
                if (dgi.ItemType == ListItemType.Footer)
                    dgi.Cells[6].Text = "平均："+nAv.ToString();
            }
            
        }
        Web Form Designer generated code

        

    }
}

本文转自高海东博客园博客，原文链接http://www.cnblogs.com/ghd258/archive/2005/10/12/253193.html，如需转载请自行联系原作者