技术资料 > .Net专区 > C#语言 : 利用c#制作简单的留言板(2)

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

March 25,2004

myconn.cs
namespace notpage
{
using System;
using System.Data.SQL ;</P><P> /// <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></P><P>对应的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;</P><P> /// <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);
      }</P><P>       protected void Page_Load(object sender, EventArgs e)
      {
         if (!IsPostBack)
         {
            //
            // Evals true first time browser hits the page
            //
         }
      }</P><P>       protected void Page_Init(object sender, EventArgs e)
      {
         //
         // CODEGEN: This call is required by the ASP+ Windows Form Designer.
         //
         InitializeComponent();
      }</P><P>       /// <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

            }
         }


      }</P><P> }
}