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" %>
对应的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
}
}
}
}
}