link.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>
	/// link 的摘要说明。
	/// </summary>
	public class link : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.RadioButton cpt;
		protected System.Web.UI.WebControls.RadioButton art;
		protected System.Web.UI.WebControls.RadioButton star;
		protected System.Web.UI.WebControls.RadioButton spt;
		protected System.Web.UI.WebControls.RadioButton fs;
		protected System.Web.UI.WebControls.RadioButton ot;
		protected System.Web.UI.WebControls.DataGrid freelink;
		protected System.Web.UI.WebControls.RadioButton all;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Button Button2;
			protected System.Web.UI.WebControls.TextBox TextBox2;
			protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.Label  Label1;
		static public string getlink;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
				if(!IsPostBack)
				{
						
					getlink="select * from link  order by id desc";
			binddata(getlink);
					}
			
		}
		public void modlink(object sender, System.EventArgs e)
		{Session.Timeout=60;
				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='" +TextBox2.Text + "'";
			OleDbConnection objConnection = new OleDbConnection(strConnection);
			OleDbCommand objCommand =new OleDbCommand(strSQL, objConnection);
			OleDbDataReader objDataReader ;
			objCommand.Connection.Open();
			objDataReader = objCommand.ExecuteReader();
	
			if (objDataReader.Read() == true) 
			{
				if (TextBox3.Text==objDataReader.GetValue(2).ToString())
				{
					Session["name"]=TextBox2.Text;
					Response.Write ("<script>window.open('mdlink.aspx')</script>");
				}
				else
					Label1.Text="密码错误";
			}
			else
				Label1.Text="没有此用户名";
		}
		public void binddata(string strmysoft)
		{
				string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
			string DataBase  = Server.MapPath("db/addlink.mdb");
			strConnection += "Data Source=" + DataBase;
		
			OleDbConnection objConnection=new  OleDbConnection(strConnection);
			OleDbDataAdapter objAdapter;
			DataSet objDataSet;
				
		objAdapter = new OleDbDataAdapter(strmysoft, objConnection);
			 objDataSet= new DataSet() ;
			objAdapter.Fill(objDataSet, "mysofts");
			freelink.DataSource = objDataSet.Tables["mysofts"].DefaultView;
			
			freelink.DataBind();}

		#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.cpt.CheckedChanged += new System.EventHandler(this.cpt_CheckedChanged);
			this.art.CheckedChanged += new System.EventHandler(this.art_CheckedChanged);
			this.star.CheckedChanged += new System.EventHandler(this.star_CheckedChanged);
			this.spt.CheckedChanged += new System.EventHandler(this.spt_CheckedChanged);
			this.fs.CheckedChanged += new System.EventHandler(this.fs_CheckedChanged);
			this.ot.CheckedChanged += new System.EventHandler(this.ot_CheckedChanged);
			this.all.CheckedChanged += new System.EventHandler(this.all_CheckedChanged);
			
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void cpt_CheckedChanged(object sender, System.EventArgs e)
		{   getlink="select * from link where kind='电脑网络'  order by id desc";
			freelink.CurrentPageIndex=0;
			binddata(getlink);
		}

		private void art_CheckedChanged(object sender, System.EventArgs e)
		{getlink="select * from link where kind='文学艺术'  order by id desc";
			freelink.CurrentPageIndex=0;
			binddata(getlink);
		}

		private void star_CheckedChanged(object sender, System.EventArgs e)
		{getlink="select * from link where kind='影视明星'  order by id desc";
			freelink.CurrentPageIndex=0;
		binddata(getlink);
		}

		private void spt_CheckedChanged(object sender, System.EventArgs e)
		{getlink="select * from link where kind='体育运动'  order by id desc";
			freelink.CurrentPageIndex=0;
			binddata(getlink);
		}

		private void fs_CheckedChanged(object sender, System.EventArgs e)
		{getlink="select * from link where kind='时尚休闲'  order by id desc";
			binddata(getlink);
		}

		private void ot_CheckedChanged(object sender, System.EventArgs e)
		{getlink="select * from link where kind='其它'  order by id desc";
			freelink.CurrentPageIndex=0;
			binddata(getlink);
		}

		private void all_CheckedChanged(object sender, System.EventArgs e)
		{getlink="select * from link  order by id desc";
	freelink.CurrentPageIndex=0;
			binddata(getlink);
		;
		}
		protected void freelink_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
		{string pagelink=getlink;
			freelink.CurrentPageIndex=e.NewPageIndex;
		 binddata(pagelink);
		}

		public void findsite(object sender, System.EventArgs e)
		{
			getlink="select * from link where sitedes like '%"+TextBox1.Text+"%'";
			freelink.CurrentPageIndex=0;
			binddata(getlink);
		}
	}
}