login.aspx.cs

这是我制作的一个小论坛源码··能够简单实现发表帖子··管理帖子·后台管理等功能

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using da;
using System.Data.SqlClient;
namespace bbs
{
	/// <summary>
	/// login 的摘要说明。
	/// </summary>
	public class login : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox TextBox_loginname;
		protected System.Web.UI.WebControls.TextBox TextBox_loginpwd;
		protected System.Web.UI.WebControls.LinkButton LinkButton_regist;
		protected System.Web.UI.WebControls.LinkButton LinkButton_lostmima;
		protected System.Web.UI.WebControls.Button Button_denglu;
		protected System.Web.UI.WebControls.Button Buttom_back;
		protected System.Web.UI.HtmlControls.HtmlInputText TextBox_login;

		private void Page_Load(object sender, System.EventArgs e)
		{
			
			// 在此处放置用户代码以初始化页面
		}

		

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.LinkButton_regist.Click += new System.EventHandler(this.LinkButton_regist_Click);
			this.LinkButton_lostmima.Click += new System.EventHandler(this.LinkButton_lostmima_Click);
			this.Button_denglu.Click += new System.EventHandler(this.Button_denglu_Click);
			this.Buttom_back.Click += new System.EventHandler(this.Buttom_back_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button_denglu_Click(object sender, System.EventArgs e)
		{	
			string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
			string sqlstr="select count(*) from users where username='"+ this.TextBox_loginname.Text+"'and pwd='"+this.TextBox_loginpwd.Text+"'";			
			SqlConnection Myconn = new  SqlConnection(ConnectionString);
			SqlCommand Mycmd=new SqlCommand(sqlstr,Myconn);
						
			try
			{
				if(Myconn.State!=ConnectionState.Open)
				{
					Myconn.Open();
				}
				int count=Convert.ToInt32(Mycmd.ExecuteScalar());
				if(count>0)
				{
					Session["UserName"]=this.TextBox_loginname.Text;
					string sql="select iUserID from users where username='"+this.TextBox_loginname.Text+"'";
					string sql2="select iPowerLevels from users where username='"+this.TextBox_loginname.Text+"'";
					da.da d=new da.da();
					DataSet ds=d.Select(sql,"users");
					DataSet myds=d.Select(sql2,"users");
					Session["userid"]=ds.Tables["users"].Rows[0][0].ToString();	
					Session["iPowerLevels"]=myds.Tables["users"].Rows[0]["iPowerLevels"].ToString();
					Response.Redirect("index.aspx");			

				}
				
				else
				{
					Response.Write("<script>alert('用户名不存在或密码错误！')</script>");
					return;
				}
				
					
					
			}
			catch(Exception ex)
			{	
				Response.Write(ex.Message);
				Myconn.Close();
			}
			finally
			{	
				Myconn.Close();
				Myconn.Dispose();
				Myconn=null;
			}
			
		
				
		
		}

		private void LinkButton_regist_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("regedit.aspx");
		}

		private void LinkButton_lostmima_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("modify.aspx");
		}

		private void Buttom_back_Click(object sender, System.EventArgs e)
		{
			return;
		}
	}
}