1using System;
  2using System.Collections;
  3using System.Data.OleDb;
  4using System.ComponentModel;
  5using System.Data;
  6using System.Drawing;
  7using System.Web;
  8using System.Web.SessionState;
  9using System.Web.UI;
 10using System.Web.UI.WebControls;
 11using System.Web.UI.HtmlControls;
 12
 13namespace temp
 14...{
 15    /**//// <summary>
 16    /// _default 的摘要说明。
 17    /// </summary>
 18    public class _default : System.Web.UI.Page
 19    ...{
 20        protected System.Web.UI.WebControls.DataGrid DG6;
 21        protected System.Web.UI.WebControls.DataGrid DG1;
 22        protected System.Web.UI.WebControls.DataGrid DG2;
 23        protected System.Web.UI.WebControls.DataGrid DG3;
 24        protected System.Web.UI.WebControls.DataGrid DG4;
 25        protected System.Web.UI.WebControls.Label Vistor;
 26        protected System.Web.UI.WebControls.DataGrid DG5;
 27    
 28        private void Page_Load(object sender, System.EventArgs e)
 29        ...{
 30            // 在此处放置用户代码以初始化页面
 31            if (!IsPostBack)
 32            ...{
 33                showdata();
 34            }
 35        }
 36        private void showdata()
 37        ...{
 38            //打开连接
 39            string  dbname=".\\dbxcl\\temp.mdb";  
 40            string  strConnection=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath (dbname)+";";
 41            OleDbConnection objConnection=new OleDbConnection(strConnection);
 42            objConnection.Open(); 
 43            DataSet myDataSet=new DataSet ();
 44
 45            //显示数据
 46            for (int i=1; i<6; i++)
 47            ...{
 48                string strSel="select top 5 * from d_heartword where d_typeid =" + i +" order by d_hwtime desc";
 49                OleDbCommand myCommand=new OleDbCommand( strSel, objConnection );
 50
 51                OleDbDataAdapter myDbAdapter=new OleDbDataAdapter ();
 52                myDbAdapter.SelectCommand=myCommand;
 53
 54
 55                string d_index="d_index"+i;
 56                myDbAdapter.Fill (myDataSet,d_index);
 57
 58                DataGrid DG= (DataGrid)FindControl("DG"+i.ToString());
 59                DG.DataSource =myDataSet.Tables[d_index];
 60                DG.DataBind ();
 61                DG.Columns [0].ItemStyle .Width =240;
 62                DG.Columns [1].ItemStyle .Width =48;
 63                DG.Columns [2].ItemStyle .Width =30;
 64            };
 65
 66            string strSelleft="select top 10 * from d_heartword order by d_hwtime desc";
 67            OleDbCommand myCommandleft=new OleDbCommand( strSelleft, objConnection );
 68
 69            OleDbDataAdapter myDbAdapterleft=new OleDbDataAdapter ();
 70            myDbAdapterleft.SelectCommand=myCommandleft;
 71
 72            myDbAdapterleft.Fill (myDataSet,"d_left");
 73
 74            DG6.DataSource =myDataSet.Tables["d_left"].DefaultView ;
 75            DG6.DataBind ();
 76
 77            //关闭连接
 78            DG1.Dispose();
 79            DG2.Dispose();
 80            DG3.Dispose();
 81            DG4.Dispose();
 82            DG5.Dispose();
 83            DG6.Dispose();
 84            myDataSet.Dispose();
 85            objConnection.Dispose();
 86
 87
 88            Vistor.Text="本站当前有： <font color=red>" + Application["user_sessions"].ToString() + "" + "</font> 位访问者 !";
 89        }
 90
 91        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 92        override protected void OnInit(EventArgs e)
 93        ...{
 94            //
 95            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 96            //
 97            InitializeComponent();
 98            base.OnInit(e);
 99        }
100        
101        /**//// <summary>
102        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
103        /// 此方法的内容。
104        /// </summary>
105        private void InitializeComponent()
106        ...{    
107            this.Load += new System.EventHandler(this.Page_Load);
108
109        }
110        #endregion
111    }
112}
113