ASP.NET中登录界面如何实现用户和密码与数据库对应才跳转否则停留在当前面
简单说现网站有一个存放数据的文件夹里有文件mydb.mdb存放有用户名密码,登录面logn.asp,求登录按钮点击跳转到index.asp的代码,用户名和密码对则跳转否则...
简单说现网站有一个存放数据的文件夹里有文件mydb.mdb存放有用户名密码,登录面logn.asp,求登录按钮点击跳转到index.asp的代码,用户名和密码对则跳转否则停留当前面。
数据库表名为members ,用户名字段user 密码字段pwd100分送了谢谢
等了好几天了无满意答案还是帮我看看是不是这样还在加什么代码又或者我的代码错了
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As New OleDbConnection
conn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0; data Source=" & Server.MapPath("~/App_Data/mydb.mdb")
Dim cmd As New OleDbCommand
cmd.Connection = conn
cmd.CommandText = "select * form members where username= TextBox1.Text pwd= TextBox2.Text "
Dim reader As OleDbDataReader
conn.Open()
reader = cmd.ExecuteReader
If reader.Read Then
Response.Redirect("~/index.asp")
Else
TextBox1.Text = "登录失败"
TextBox2.Text = "登录失败"
End If</p 展开
数据库表名为members ,用户名字段user 密码字段pwd100分送了谢谢
等了好几天了无满意答案还是帮我看看是不是这样还在加什么代码又或者我的代码错了
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As New OleDbConnection
conn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0; data Source=" & Server.MapPath("~/App_Data/mydb.mdb")
Dim cmd As New OleDbCommand
cmd.Connection = conn
cmd.CommandText = "select * form members where username= TextBox1.Text pwd= TextBox2.Text "
Dim reader As OleDbDataReader
conn.Open()
reader = cmd.ExecuteReader
If reader.Read Then
Response.Redirect("~/index.asp")
Else
TextBox1.Text = "登录失败"
TextBox2.Text = "登录失败"
End If</p 展开
6个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询