aspn.net学者进?
在用asp.net作后台管理时,要用到管理员登陆页,可是怎么才能实现与数据库中的表admin中的字段name进行比较,相同时才能正常登陆呢?
参考答案:先建立数据库连接,取得数据集
然后将相应的字段和用户输入相比较
可以在用户密码输入确定事件中处理
下面是我做过的小程序,学生管理系统登录页管理,希望能给你点参考
Session("Sort") = DropDownList1.SelectedItem.Text
Session("User") = TextBox1.Text
Session("PassWord") = Password1.Value
Dim myConnection As New SqlConnection
Dim strSQL As String
Dim sda1 As SqlDataAdapter
Dim sda2 As SqlDataAdapter
Dim ds1 As New DataSet
Dim ds2 As New DataSet
Dim rows1 As Integer
Dim rows2 As Integer
Dim i As Integer
Dim a As Boolean = False
myConnection.ConnectionString = "workstation id=TTT;packet size=4096;user id=sa;data source=TTT;persist security info=False;initial catalog=学生系统"
myConnection.Open()
strSQL = "select 用户类别,用户名,密码 from 特殊用户"
sda1 = New SqlDataAdapter(strSQL, myConnection)
sda1.Fill(ds1, "特殊用户")
rows1 = ds1.Tables(0).Rows.Count - 1
sda2 = New SqlDataAdapter("select 学号,密码 from 学生信息", myConnection)
sda2.Fill(ds2)
rows2 = ds2.Tables(0).Rows.Count - 1
For i = 0 To rows1
If Session("Sort") = ds1.Tables(0).Rows(i).Item(0) And Session("User") = ds1.Tables(0).Rows(i).Item(1) And _
Session("PassWord") = ds1.Tables(0).Rows(i).Item(2) Then
a = True
End If
Next
If a = False Then
For i = 0 To rows2
If Session("sort") = "学生" And Session("User") = ds2.Tables(0).Rows(i).Item(0) And Session("PassWord") = ds2.Tables(0).Rows(i).Item(1) Then
a = True
End If
Next
End If
If a = True Then
Response.Redirect("GuanLiXiTong.aspx")
Else
Response.Write("您的用户名或密码有错")
End If
myConnection.Close()