using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.OleDb;
public?partial?class?Default2?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
???????
????????this.xinwenfillgv（）;//調(diào)用用戶自定義的xinwenfillgv（）方法
????????this.fillgougao（）;//調(diào)用用戶自定義的fillgougao（）方法
????????this.qianfeifillgv（）;//調(diào)用用戶自定義的qianfeifillgv（）方法
????????
????}
????public?void?xinwenfillgv（）????????????//用戶自定義的方法
????{
????????OleDbConnection?con?=?DB.createDB（）;//調(diào)用用戶自定義的DB類的createDB（）的方法
????????OleDbCommand?cmd?=?new?OleDbCommand（）;//聲明一個(gè)OleDbCommand的對象并將該對象cmd實(shí)例化
????????cmd.Connection?=?con;
????????con.Open（）;//打開數(shù)據(jù)庫連接
????????OleDbDataAdapter?sda?=?new?OleDbDataAdapter（“select?top?9?*?from?tb_xinwen?order?by?fabushijian?desc“?con）;//從新聞表tb_xinwen按發(fā)布時(shí)間fabushijian的降序排序
????????DataSet?ds?=?new?DataSet（）;//聲明一個(gè)DataSet的對象并將該對象ds實(shí)例化
????????sda.Fill（ds?“tb_xinwen“）;//將新聞表tb_xinwen填充到數(shù)據(jù)庫中
????????this.gvXw.DataSource?=?ds;
????????//this.GridView2.DataKeyNames?=?new?string[]?{?“title“?};?
????????this.gvXw.DataBind（）;//將數(shù)據(jù)綁定到GridView控件中
????????for?（int?i?=?0;?i?<=?gvXw.Rows.Count?-?1;?i++）
????????{
????????????DataRowView?mydrv;??//聲明一個(gè)DataRowView的對象
????????????string?gintro;
????????????if?（this.gvXw.PageIndex?==?0）
????????????{
????????????????mydrv?=?ds.Tables[“tb_xinwen“].DefaultView[i];
????????????????gintro?=?Convert.ToString（mydrv[“title“]）;
????????????????this.gvXw.Rows[i].Cells[0].Text?=?SubStr（gintro?10）;
????????????}
????????????else
????????????{
????????????????mydrv?=?ds.Tables[“tb_xinwen“].DefaultView[i?+?（5?*?gvXw.PageIndex）];
????????????????gintro?=?Convert.ToString（mydrv[“title“]）;
????????????????this.gvXw.Rows[i].Cells[0].Text?=?SubStr（gintro?10）;
????????????}
????????}
????????con.Close（）;//關(guān)閉數(shù)據(jù)庫連接
????}
???
????public?void?fillgougao（）
????{
????????OleDbConnection?con?=?DB.createDB（）;//調(diào)用用戶自定義的DB類的createDB（）的方法
????????OleDbCommand?cmd?=?new?OleDbCommand（“?select??*?from?tb_zhannei“?con）;
????????con.Open（）;//打開數(shù)據(jù)庫連接
????????OleDbDataReader?sdr?=?cmd.ExecuteReader（）;?
????????sdr.Read（）;//
????????this.lblGgxx.Text?=?sdr.GetString（0）;//從數(shù)據(jù)庫中讀取第一個(gè)數(shù)據(jù)放到Label標(biāo)簽中
????????sdr.Close（）;//關(guān)閉閱讀器
????????con.Close（）;//關(guān)閉數(shù)據(jù)庫連接
????}
????public?void?qianfeifillgv（）
????{
????????OleDbConnection?con?=?DB.createDB（）;
????????con.Open（）;?//打開數(shù)據(jù)庫連接
????????OleDbCommand?cmd?=?new?OleDbCommand（）;//調(diào)用用戶自定義的DB類的createDB（）的方法
????????OleDbDataAdapter?sda?=?new?OleDbDataAdapter（“select?top?10?*?from?tb_qianfei“?con）;
????????DataSet?ds?=?new?DataSet（）;?????????//聲明一個(gè)DataSet的ds對象并將其實(shí)例化
????????sda.Fill（ds?“tb_qianfei“）;
????????this.gvQf.DataSource?=?ds;
????????this.gvQf.DataBind（）;//將數(shù)據(jù)綁定到GridView控件中
????????con.Close（）;//關(guān)閉數(shù)據(jù)庫連接
?

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????652??2007-11-20?18:44??07\WebSite3\App_Code\DB.cs

?????文件?????729088??2011-03-29?10:17??07\WebSite3\App_Data\db_wygl.mdb

?????文件???????5299??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\CSs\default.css

?????文件????????602??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\calendar.html

?????文件?????????95??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\calendarbottom.html

?????文件?????????92??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\calendartop.html

?????文件???????2189??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\crystalexportdialog.htm

?????文件???????2707??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\crystalprinthost.html

?????文件?????????84??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\calendar.gif

?????文件???????1410??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\crlogo.gif

?????文件????????617??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\export.gif

?????文件????????283??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\exportd.gif

?????文件???????1244??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\export_over.gif

?????文件?????????78??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\First.gif

?????文件?????????78??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\Firstd.gif

?????文件???????1251??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\first_over.gif

?????文件????????595??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\gotopage.gif

?????文件????????176??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\gotopaged.gif

?????文件???????1226??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\gotopage_over.gif

?????文件????????257??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\grouptree.gif

?????文件????????230??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\grouptreed.gif

?????文件????????179??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\grouptreepressed.gif

?????文件???????1215??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\grouptree_over.gif

?????文件?????????79??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\Last.gif

?????文件?????????79??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\Lastd.gif

?????文件???????1251??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\last_over.gif

?????文件?????????73??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\Next.gif

?????文件?????????73??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\Nextd.gif

?????文件???????1252??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\next_over.gif

?????文件?????????73??2005-11-12?00:00??07\WebSite3\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\Prev.gif

............此處省略206個(gè)文件信息