当前文件： BasicGuestBook/Default.aspx.cs[1K，2009-6-12 11:33:26]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11
12
13public partial class _Default : System.Web.UI.Page 
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!IsPostBack)
18        ...{
19            SetBind();
20        }
21    }
22    protected void btn_sendmessage_Click(object sender, EventArgs e)
23    ...{
24        string tb_UserName = this.tb_UserName.Text.ToString();
25        string tb_Message = this.tb_Message.Text.ToString();
26        string posttime = DateTime.Now.ToString();
27
28        SqlConnection conn = new SqlConnection(@"server=(local)\sqlexpress;database=Guestbook;trusted_connection=true");
29        string sql = "insert into tbguestbook (username,posttime,message,isreplied,reply) values ('"+tb_UserName+"','"+posttime+"','"+tb_Message+"',0,'')";
30        SqlCommand cmd = new SqlCommand(sql, conn);
31        conn.Open();
32        cmd.ExecuteNonQuery();
33        conn.Close();
34    }
35    private void SetBind()
36    ...{
37        SqlConnection conn = new SqlConnection(@"server=(local)\sqlexpress;database=Guestbook;trusted_connection=true");
38        string Sql = "select * from tbguestbook order by posttime desc";
39        SqlDataAdapter da = new SqlDataAdapter(Sql, conn);
40        DataSet ds = new DataSet();
41        da.Fill(ds);
42        DataTable dt = ds.Tables[0];
43        rpt_Message.DataSource = dt;
44        rpt_Message.DataBind();
45    }
46    
47}
48