mdlink.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>
	/// mdlink 的摘要说明。
	/// </summary>
	public class mdlink : System.Web.UI.Page
	{
		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.Button Button1;
	  static public string getname;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
				if (!Page.IsPostBack )
		   {
				   getname=Session["name"].ToString ();
			   string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
			   string DataBase  = Server.MapPath("db/addlink.mdb");
			   strConnection += "Data Source=" + DataBase;
			   OleDbDataReader objDataReader ;
			   string strSQL = "SELECT * FROM link where name='"+getname+"'";
			   OleDbConnection objConnection = new OleDbConnection(strConnection);
			   OleDbCommand objCommand =new OleDbCommand(strSQL, objConnection);
			   objCommand.Connection.Open();
			   objDataReader = objCommand.ExecuteReader();
			   if (objDataReader.Read() == true) 
			   {
				   TextBox2.Text=objDataReader.GetValue(2).ToString();
				   TextBox3.Text=objDataReader.GetValue(3).ToString();
				   TextBox4.Text=objDataReader.GetValue(7).ToString();
				   TextBox5.Text=objDataReader.GetValue(4).ToString();
				   DropDownList1.SelectedItem.Text =objDataReader.GetValue(6).ToString();
			   }
                
		   }
		}

		#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 sql = "update link set pasw='"+TextBox2.Text+"',sitename='"+TextBox3.Text+"',addr='"+TextBox5.Text+"',sitedes='"+TextBox4.Text+"',kind='"+DropDownList1.SelectedItem.Text+"' where name='"+getname+"'";
			OleDbConnection objConnection = new OleDbConnection(strConnection);
			OleDbCommand addCommand =new OleDbCommand(sql, objConnection);
			addCommand.Connection.Open();
			addCommand.ExecuteNonQuery();
			addCommand.Connection.Close();
			Response.Write ("<script>alert(\"修改成功！点击确定按钮关闭窗口！\");window.close()</script>");
			Response.End();
		
		}
	}
}