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

2022-07-15 80酷酷网 80kuku.com

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

    /// <summary>
    ///    Summary description for myconn.
    /// </summary>
    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" %>
<html><head>
<meta content="Microsoft Visual Studio 7.0" name=GENERATOR>
<meta content=C# name=CODE_LANGUAGE></head>
<body>
<form method=post runat="server">
<table cellSpacing=1 cellPadding=1 width="88%" border=0>
  <tr>
    <td>留言主题：</TD>
    <td><asp:textbox id=txtTitle runat="server" maxlength="80" columns="65"></asp:textbox></TD></TR>
  <tr>
    <td>姓名：</TD>
    <td><asp:textbox id=txtAuthor runat="server" maxlength="40" columns="20"></asp:textbox></TD></TR>
  <tr>
    <td>留言内容</TD>
    <td><asp:textbox id=txtContent runat="server" maxlength="2000" columns="50" rows="20" TextMode="MultiLine"></asp:textbox><asp:button
      id=btnSubmit runat="Server"
  text="确认"></asp:button></TD></TR></TABLE></FORM>

  </body></html>

对应的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>
    ///    Summary description for AddTopic.
    /// </summary>
    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();
        }

        /// <summary>
        ///    Required method for Designer support - do not modify
        ///    the contents of this method with the code editor.
        /// </summary>
        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 ("<p align=center class=cn>成功留言，点击<a href = list.aspx>此处</a>查看留言列表！。</p>") ;
                    }
                }
                catch(Exception exp)
                {
#if DEBUG
                    Response.Write ("出现异常：" + exp.Message) ;
                    return ;
#endif//DEBUG

                }
            }


        }

    }
}