regest.aspx.cs

比较简单的网站登陆器

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data .OleDb ;
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 todotnet_kinghome
{
	/// <summary>
	/// regest 的摘要说明。
	/// </summary>
	public class regest : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.TextBox username;
		protected System.Web.UI.WebControls.TextBox pasw;
		protected System.Web.UI.WebControls.TextBox firpasw;
		protected System.Web.UI.WebControls.TextBox sitedes;
		protected System.Web.UI.WebControls.TextBox hobby;
		protected System.Web.UI.WebControls.TextBox usermail;
		protected System.Web.UI.WebControls.TextBox sitename;
		protected System.Web.UI.WebControls.TextBox siteurl;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Label wrong;
		protected System.Web.UI.WebControls.TextBox oicq;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
		}
		private string check(string v)
		{
			v = v.Replace("'","");
			v = Server.HtmlEncode(v);
			return v;
		}
		public void Button1_click(object sender, System.EventArgs e)
		{   string getusername=username.Text;
			string getpasw=pasw.Text;
            string getsitedes=sitedes.Text;
			string gethobby=hobby.Text;
			string getoicq=oicq.Text;
			string getusermail=usermail.Text;
			string getsitename=sitename.Text;
			string getsiteurl=siteurl.Text;
			string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
			string DataBase  = Server.MapPath("db/hsjdata.mdb");
			strConnection += "Data Source=" + DataBase;
			string strSQL = "SELECT * FROM ps where username='" +getusername+ "'";
			OleDbConnection objConnection = new OleDbConnection(strConnection);
			OleDbCommand objCommand =new OleDbCommand(strSQL, objConnection);
			OleDbDataReader objDataReader ;
			objCommand.Connection.Open();
			objDataReader = objCommand.ExecuteReader();
			if (objDataReader.Read() == true) 
			{
				wrong.Text = "对不起，该用户名已经被注册！";
				return;}
			objCommand.Connection.Close();
				string sql = "insert into ps (pw,username,email,sitename,siteadr,sitedes,oicq,hobby) values ('" + check(pasw.Text) + "','"+ check(username.Text) + "','" + check(usermail.Text) + "','" +check(sitename.Text) + "','" + check(siteurl.Text) + "','" + check(sitedes.Text) + "','" + check(oicq.Text) + "','" + check(hobby.Text) + "')";
			OleDbCommand addCommand =new OleDbCommand(sql, objConnection);
			addCommand.Connection.Open();
			addCommand.ExecuteNonQuery();
			addCommand.Connection.Close();
			Response.Write ("<script>alert(\"注册成功！点击确定按钮关闭窗口！\");window.close()</script>");
			Response.End();

		}
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}