一、新建一个数据库 新建一个access数据user.mdb。 新建一个user表,添加:UserId(文本类型)及Password(文本类型)两个字段。 二、新建一个default.aspx文件。 在Web Form里: 加入两个Label控件,Text属性分别为“登录名”和“密码”; 加入两个TextBox控件,ID属性分别为“Userid”和“Pwd”,Text属性均为空; 加入两个RequiredFieldValidato控件,ID属性分别为“rfvUserid”和“rfvPwd”,Text属性分别为“请输入登录名!”和“请输入登录密码!”,ControlToValidate属性分别为"Userid"和"Pwd"; 加入一个Button控件,ID属性为“LogButton”,Text属性别为“登录”; 最后加入一个Label控件,ID属性为“Msg”。 Default.aspx源代码如下: <%@ Page language="c#" Codebehind="default.aspx.cs" AutoEventWireup="false" Inherits="lsj.WebForm1" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <meta name="GENERATOR" Content="Microsoft Visual Studio 7.0"> <meta name="CODE_LANGUAGE" Content="C#"> <meta name="vs_defaultClientScript" content="JavaScript (ECMAScript)"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> </HEAD> <body MS_POSITIONING="GridLayout"> <FONT face="宋体"> <form runat="server" ID="Form1"> <asp:Label
Height="26px">登录名</asp:Label> <asp:Label >请输入登录密码!</asp:RequiredFieldValidator> </form> </FONT> </body> </HTML>
三、编写default.aspx.cs文件。 双击LogButton, 1、加入using System.Data.OleDb; 2、先在class中声明: public string strConnection; OleDbConnection myConn; 3、加入数据库链接: 把下面代码加入“Page_Init(object sender, EventArgs e)”的“InitializeComponent();”后面. string strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(".")+"..user.mdb;"; myConn=new OleDbConnection(strConnection); 4、在LogButton_Click(object sender, System.EventArgs e)事件中加入下面的代码: string userid,pwd; userid=Userid.Text; pwd=Pwd.Text; string mySel="SELECT count(*) as iCount from user where UserID=""+userid+""";
OleDbCommand myCmd1=new OleDbCommand(mySel,myConn); myCmd1.Connection.Open(); OleDbDataReader Dr1; Dr1=myCmd1.ExecuteReader(); Dr1.Read(); string Count=Dr1["iCount"].ToString(); Dr1.Close(); myCmd1.Connection.Close(); string DrPwd,DrRoles; if(Count!="0") { mySel="SELECT * from user where UserID=""+userid+"""; OleDbCommand myCmd=new OleDbCommand(mySel,myConn); myCmd.Connection.Open(); OleDbDataReader Dr; Dr=myCmd.ExecuteReader(); Dr.Read(); DrPwd=Dr["Password"].ToString(); Dr.Close(); if(DrPwd==pwd) else Msg.Text="登录密码错."; } else Msg.Text="没有这个用户.";
好了,全部工作已经完成,default.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 System.Data.OleDb;
namespace lsj { /// <summary> /// Summary description for WebForm1. /// </summary> public class WebForm1 : System.Web.UI.Page { protected System.Web.UI.WebControls.Label Label1; protected System.Web.UI.WebControls.Label Label2; protected System.Web.UI.WebControls.TextBox Userid; protected System.Web.UI.WebControls.Button LogButton; protected System.Web.UI.WebControls.TextBox Pwd; protected System.Web.UI.WebControls.Label Msg; protected System.Web.UI.HtmlControls.HtmlForm Form1; protected System.Web.UI.WebControls.RequiredFieldValidator rfvUserid; protected System.Web.UI.WebControls.RequiredFieldValidator rfvPwd; public string strConnection; OleDbConnection myConn;
public WebForm1() { Page.Init += new System.EventHandler(Page_Init); }
private void Page_Load(object sender, System.EventArgs e)
private void Page_Init(object sender, EventArgs e) { InitializeComponent(); string strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(".")+"..user.mdb;"; //user.mdb放在与aspx文件同一目录下 myConn=new OleDbConnection(strConnection); }
private void InitializeComponent() { this.LogButton.Click += new System.EventHandler(this.LogButton_Click); this.Load += new System.EventHandler(this.Page_Load); }
private void LogButton_Click(object sender, System.EventArgs e) { string userid,pwd; userid=Userid.Text; pwd=Pwd.Text; string mySel="SELECT count(*) as iCount from user where UserID=""+userid+""";
OleDbCommand myCmd1=new OleDbCommand(mySel,myConn); myCmd1.Connection.Open(); OleDbDataReader Dr1; Dr1=myCmd1.ExecuteReader(); Dr1.Read(); string Count=Dr1["iCount"].ToString(); Dr1.Close(); myCmd1.Connection.Close(); string DrPwd,DrRoles; if(Count!="0") { mySel="SELECT * from user where UserID=""+userid+"""; OleDbCommand myCmd=new OleDbCommand(mySel,myConn); myCmd.Connection.Open(); OleDbDataReader Dr; Dr=myCmd.ExecuteReader(); Dr.Read(); DrPwd=Dr["Password"].ToString(); Dr.Close(); if(DrPwd==pwd) else Msg.Text="登录密码错."; } else Msg.Text="没有这个用户."; } } }
|
请发表评论