adlink.aspx.cs

aspx自助链接系统(.net)

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__freelink
{
	/// <summary>
	/// adlink 的摘要说明。
	/// </summary>
	public class adlink : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.TextBox TextBox5;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.Label wrong;
		protected System.Web.UI.WebControls.Button Button1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
		}

		#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.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
			string DataBase  = Server.MapPath("db/addlink.mdb");
			strConnection += "Data Source=" + DataBase;
			string strSQL = "SELECT * FROM link where name='" +TextBox1.Text + "'";
			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 link (name,pasw,sitename,addr,sitedes,kind) values ('" + TextBox1.Text + "','"+ TextBox2.Text  + "','" + TextBox3.Text  + "','" +TextBox5.Text + "','" + TextBox4.Text  + "','" + DropDownList1.SelectedItem.Text  + "')";
			OleDbCommand addCommand =new OleDbCommand(sql, objConnection);
			addCommand.Connection.Open();
			addCommand.ExecuteNonQuery();
			addCommand.Connection.Close();
			Response.Write ("<script>alert(\"登陆成功！点击确定按钮关闭窗口！\");window.close()</script>");
			Response.End();
		}
	}
}