利用c#制作简单的留言板 (2)

myconn.cs
namespace notpage
{
    using System;
    using System.Data.SQL ;

    ///

    ///    Summary description for myconn.
    ///

    public class myconn:System.Data.SQL.SQLConnection
    {
        private void InitializeComponent ()
        {
        }
    
        public myconn()
        {
            //
            // TODO: Add Constructor Logic here
            //
            this.Database = "back" ;
            this.DataSource = "LUOCHANG" ;
            this.UserID = "sa" ;
            this.Password = "" ;
        }
    }
}
添加留言addTopic.aspx
<%@ Page language="c#" Codebehind="AddTopic.cs" AutoEventWireup="false" Inherits="notpage.AddTopic" %>

  
    
    
  
    
    
  
    
    

留言主题：
姓名：
留言内容	id=btnSubmit runat="Server"   text="确认">

    
  

对应的cs
namespace notpage
{
    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;

    ///

    ///    Summary description for AddTopic.
    ///

    public class AddTopic : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.TextBox txtContent;
        protected System.Web.UI.WebControls.TextBox txtAuthor;
        protected System.Web.UI.WebControls.TextBox txtTitle;
        protected System.Web.UI.WebControls.Button btnSubmit;
    
    public AddTopic()
    {
        Page.Init += new System.EventHandler(Page_Init);
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //
                // Evals true first time browser hits the page
                //
            }
        }

        protected void Page_Init(object sender, EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP+ Windows Form Designer.
            //
            InitializeComponent();
        }

        ///

        ///    Required method for Designer support - do not modify
        ///    the contents of this method with the code editor.
        ///

        private void InitializeComponent()
        {
            btnSubmit.Click += new System.EventHandler (this.OnSubmit);
            this.Load += new System.EventHandler (this.Page_Load);
        }
        public void OnSubmit(Object sender , EventArgs e)
        {
            
            
            if (Page.IsValid)
            {
                //数据入库
                try
                {
            
                    notepage objNp = new notepage();
                    objNp.Title = txtTitle.Text;
                    objNp.Author = txtAuthor.Text;
                    objNp.Content = txtContent.Text;
                    objNp.adddate = System.DateTime.Now;
                    notepage objNp1 = new notepage();
                    if(objNp1.AddTopic(objNp))
                    {
                        
                        Response.Write ("

成功留言，点击此处查看留言列表！。

") ;
                    }
                }
                catch(Exception exp)
                {
#if DEBUG
                    Response.Write ("出现异常：" + exp.Message) ;
                    return ;
#endif//DEBUG
                
                }
            }
            
            
        }

    }
}