loginauthenticatecode.aspx.cs

《圣殿祭司的ASP.NET 2.0开发详解——使用C#》光盘内容.包含了书籍所含的源代码.非常经典的一本asp.net2.0的书籍

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;
using System.Data.SqlClient;
using System.Web.Configuration;

public partial class LoginAuthenticateCode : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		setLoginControl();	//调用建立LoginControl
    }

	//建立Login控件
	private void setLoginControl()
	{
		//建立Login控件的实例
		System.Web.UI.WebControls.Login userLogin = new System.Web.UI.WebControls.Login();

		//设置Login的Title
		userLogin.TitleText = "3C会员";
		userLogin.TitleTextStyle.BackColor = Color.DarkRed;
		userLogin.TitleTextStyle.ForeColor = Color.White;
		userLogin.InstructionText = "用户登录";
		userLogin.ToolTip = "请输入您的会员帐号密码";
		userLogin.Width = Unit.Pixel(200);

		//设置验证成功后所要导向的网页
		userLogin.DestinationPageUrl = "LoginMessage.aspx";	

		//设置Login控件外观
		userLogin.BackColor = Color.LightYellow;
		userLogin.BorderStyle = BorderStyle.Solid;
		userLogin.BorderWidth = Unit.Pixel(1);
		userLogin.Font.Size = 8;
		

		//设置用户名及密码文字
		userLogin.UserNameLabelText = "会员帐号:";
		userLogin.PasswordLabelText = "会员密码:";
		userLogin.TextBoxStyle.BackColor = Color.LightBlue;	//设置TextBox背景
		userLogin.TextBoxStyle.Width = Unit.Pixel(80);	//设置TextBox宽度

		//设置登录按钮
		userLogin.LoginButtonText = "登录";
		userLogin.LoginButtonStyle.BackColor = Color.LightPink;
		userLogin.LoginButtonStyle.Font.Size = 8;
		
		//设置记忆属性
		userLogin.RememberMeText = "请记忆我的身份";
		
		//建立自定义的验证事件
		userLogin.Authenticate += new AuthenticateEventHandler(userLogin_Authenticate);
		//将Login控件加入Web Form
		Page.FindControl("form1").Controls.Add(userLogin);
	}

	//自定义验证
	void userLogin_Authenticate(object sender, AuthenticateEventArgs e)
	{
		//这段可自定义验证的程序，若您已有帐号的数据库，可以在这里用ADO.NET的方式
		//连接自己的数据库来验证

		//取得Web.config中设置的数据库连接字符串
		string connString = WebConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;
		SqlConnection conn = new SqlConnection(connString);
		conn.Open();

		//或是您也可以直接将连接字符串写在程序之中
		//string connString = "data source=.;initial catalog=vs2005;user id=sa;password=test";
		//SqlConnection conn = new SqlConnection(connString);
		//conn.Open();

		string SqlStr = "select ID from UserAccount where ID='";
		SqlStr += ((System.Web.UI.WebControls.Login)sender).UserName;
		SqlStr += "' and Password='" + ((System.Web.UI.WebControls.Login)sender).Password + "'";

		SqlCommand cmd = new SqlCommand(SqlStr,conn);

		//若帐号及密码符合则返回一个Object类型（ID字段）
		//故必须将Object转型为字符串
		string txtID = (string)cmd.ExecuteScalar();

		cmd.Dispose();
		conn.Close();
		conn.Dispose();

		//判断txtID是否为空值，非空值则为false，空值为true
		if (!string.IsNullOrEmpty(txtID))
		{
			e.Authenticated = true;	//验证通过
		}
		else
		{
			e.Authenticated = false;//验证失败
		}
	}

}