1using System;
 2using System.Collections;
 3using System.ComponentModel;
 4using System.Data;
 5using System.Drawing;
 6using System.Web;
 7using System.Web.SessionState;
 8using System.Web.UI;
 9using System.Web.UI.WebControls;
10using System.Web.UI.HtmlControls;
11using System.Data.OleDb;
12
13namespace StudentSys
14...{
15    /**//// <summary>
16    /// guest 的摘要说明。
17    /// </summary>
18    public class guest : System.Web.UI.Page
19    ...{
20        protected System.Web.UI.WebControls.Label EmpMonthForm_Title;
21        protected System.Web.UI.WebControls.TextBox title;
22        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
23        protected System.Web.UI.WebControls.TextBox name;
24        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
25        protected System.Web.UI.WebControls.TextBox body;
26        protected System.Web.UI.WebControls.DataGrid ml;
27        protected System.Web.UI.WebControls.Button Button1;
28    
29        private void Page_Load(object sender, System.EventArgs e)
30        ...{
31           
32            OleDbConnection myConn = new OleDbConnection("Provider=SQLOLEDB;server=(local);database=StudentManageSys;UId=sa;Pwd=sa");
33            OleDbDataAdapter  myAdapter = new OleDbDataAdapter("select ID, 标题, 署名, 正文,ip地址 from Guest order by id desc", myConn);
34            DataSet ds = new DataSet();
35            myConn.Open();
36            myAdapter.Fill(ds, "Guest");
37            ml.DataSource=ds.Tables["Guest"].DefaultView;
38            ml.DataBind();
39            myConn.Close();
40        }
41        
42        public void Submit_Click(object sender, System.EventArgs e)
43        ...{
44            OleDbConnection myConn = new OleDbConnection("Provider=SQLOLEDB;server=(local);database=StudentManageSys;UId=sa;Pwd=sa");
45            string myInsertQuery = "insert into guest (标题, 署名, 正文, ip地址) values ('"+title.Text+"', '"+ name.Text + "', '" + body.Text + "', '" + Request.UserHostAddress.ToString() + "')";
46            OleDbCommand myOleDbCommand = new OleDbCommand(myInsertQuery);
47            myOleDbCommand.Connection = myConn;
48            myConn.Open();
49            myOleDbCommand.ExecuteNonQuery();
50            myOleDbCommand.Connection.Close();
51            Response.Redirect("guest.aspx");
52        }
53
54        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
55        override protected void OnInit(EventArgs e)
56        ...{
57            //
58            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
59            //
60            InitializeComponent();
61            base.OnInit(e);
62        }
63        
64        /**//// <summary>
65        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
66        /// 此方法的内容。
67        /// </summary>
68        private void InitializeComponent()
69        ...{    
70            this.Load += new System.EventHandler(this.Page_Load);
71
72        }
73        #endregion
74    }
75}
76