日期:2014-05-19  浏览次数:20968 次

初学ASP.NET登录用户名密码验证问题,加SQL
那个大哥给一个完整呢,用户登录,用户名、密码验证问题,加上有SQL的连接语句,即从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;
开始,不完整的小弟看不懂,给出的就给分!谢谢!


------解决方案--------------------
MSDN上有,我这里有,太复杂,你不定看的懂
------解决方案--------------------
来个简单的吧access数据库库名db 表pUser 字段uID,Upass

链接字符串中 Server.MapPath( "../db/db.mdb ")一定要给绝对正确的路径


private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
this.romNum();
}
}
//生成随机数
private void romNum()
{
Random rd=new Random();
string s= " ";
for(int i=1;i <5;++i)
{
s+=rd.Next(1,10).ToString();
}
this.verifycode2.Value = s;
this.divNum.InnerHtml = s;
}


private void btnLogin_Click(object sender, System.EventArgs e)
{
if(this.verifycode.Text!=this.verifycode2.Value)
{
Response.Write( " <script> alert( '验证码输入错误! ') </script> ");
return;
}
OleDbConnection con = new OleDbConnection( "provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath( "../db/db.mdb ") );
con.Open();
string a = "select count(*) from pUser where userID = ' "+this.UserName.Text+ " ' and userPass= ' "+this.PassWord.Text+ " ' ";
OleDbCommand cmd = new OleDbCommand( "select count(*) from pUser where uID = ' "+this.UserName.Text+ " ' and uPass= ' "+this.PassWord.Text+ " ' ",con);
int i = Convert.ToInt32( cmd.ExecuteScalar());
con.Close();
if(i> 0)
{
Response.Write( " <script> alert( '登录成功! ') </script> ");
}
else
{
Response.Write( " <script> alert( '用户名或密码错误! ') </script> ");
}
}
------解决方案--------------------
aspx代码片断:
<tr>
<td style= "WIDTH: 64px " align= "right " height= "25 "> 用 户: </td>
<td noWrap> <asp:textbox id= "txtUserName " runat= "server " Width= "200px " MaxLength= "50 " Columns= "16 " CssClass= "b_input "> </asp:textbox> <asp:requiredfieldvalidator id= "RequiredFieldValidator1 " runat= "server " ErrorMessage= "请输入用户名 " ControlToValidate= "txtUserName "> </asp:requiredfieldvalidator> </td>
</tr>
<tr>
<td style= "WIDTH: 64px " align= "right " height= "25 "> 密 码: </td>
<td noWrap> <asp:textbox id= "txtUserPass " runat= "server " Width= "200px " MaxLength= "50 " Columns= "16 " CssClass= "b_input "
TextMode= "Password "> </asp:textbox> <asp:requiredfieldvalidator id= "RequiredFieldValidator2 " runat= "server " ErrorMessage= "请输入密码 " ControlToValidate= "TxtUserPass "> </asp:requiredfieldvalidator> </td>
</tr>
<tr>
<td colSpan= &qu