postlword.aspx.cs

随便上传一文章 随便上传一文章 随便上传一文章 随便上传一文章

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;	// 需要操作 Access 数据库
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace TraceLWord1
{
	/// <summary>
	/// PostLWord 发送留言到数据库
	/// </summary>
	public class PostLWord : System.Web.UI.Page
	{
		// 留言内容编辑框
		protected System.Web.UI.HtmlControls.HtmlTextArea m_txtContent;
		// 提交按钮
		protected System.Web.UI.HtmlControls.HtmlInputButton m_btnPost;

		/// <summary>
		/// PostLWord.aspx 页面加载函数
		/// </summary>
		private void Page_Load(object sender, System.EventArgs e)
		{
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			InitializeComponent();
			base.OnInit(e);
		}

		private void InitializeComponent()
		{    
			this.Load+=new System.EventHandler(this.Page_Load);
			this.m_btnPost.ServerClick+=new EventHandler(Post_ServerClick);
		}
		#endregion

		/// <summary>
		/// 发送留言信息到数据库
		/// </summary>
		private void Post_ServerClick(object sender, EventArgs e)
		{
			// 获取留言内容
			string textContent=this.m_txtContent.Value;

			// 留言内容不能为空
			if(textContent=="")
				throw new Exception("留言内容为空");

			string mdbConn=@"PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA Source=C:\DbFs\TraceLWordDb.mdb";
			string cmdText="INSERT INTO [LWord]([TextContent]) VALUES(@TextContent)";

			OleDbConnection dbConn=new OleDbConnection(mdbConn);
			OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn);

			// 设置留言内容
			dbCmd.Parameters.Add(new OleDbParameter("@TextContent", OleDbType.LongVarWChar));
			dbCmd.Parameters["@TextContent"].Value=textContent;

			try
			{
				dbConn.Open();
				dbCmd.ExecuteNonQuery();
			}
			catch
			{
				throw;
			}
			finally
			{
				dbConn.Close();
			}

			// 跳转到留言显示页面
			Response.Redirect("ListLWord.aspx", true);
		}
	}
}