login.ascx
由于在页面上很频繁使用登陆，把它做成一个控件是很有必要的，下面就是我写的一个简单的登陆控件，大家可以根据的需要完善一下。
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Oledb" %>
<script language="VB" runat="server">
Sub Page_Load(sender As Object,e As EventArgs)
session("Accessed")=false
If session("UserName")="" And Not IsPassLogin() then
lblLogin.visible=true
lblMessage.visible=false
IsPassLogin()
else
lblMessage.Text=ShowPrompt(True)
lblMessage.visible=true
lblLogin.visible=false
End If
End Sub
'用户登陆验证
Public Function IsPassLogin() As Boolean
Dim MyConnection As OledbConnection
Dim strConnection As String="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("DataBase/popmarry.mdb")
MyConnection=New OledbConnection(strConnection)
Dim sqlCommand="SELECT * FROM InMember WHERE MemberID='" & UserID & "'" & " AND Pwd='" & UserPassword & "'"
Dim MyAdapter As New OleDbDataAdapter(sqlCommand,MyConnection)
Dim ds As DataSet=New DataSet()
MyAdapter.Fill(ds,"InMember")
Dim dt As DataTable=ds.Tables("InMember")
If dt.Rows.Count>0 Then
Session("UserName")=UserID
Return(true)
Else
Return(false)
End If
End Function
'显示登陆信息
Public Function ShowPrompt(bolInfo As Boolean) As String
If bolInfo Then
Dim strWelcome As String
strWelcome="<table width='165' cellpadding='3' border='0' align='center'><tr><td align='center'>欢迎您,<font color='#FF0000'>" & Session("UserName") & "</font></td></tr><tr><td align='center'>"
strWelcome &="<table width='150' border='0'><tr><td align='center'>状态: <font color='#FF3300'>新婚网会员</font></td></tr></table>"
strWelcome &="<table width='110' border='0'><tr><td align='center'>控制面板</td><td align='center'><a onclick='return LogoutConfirm()' href='login/logout.aspx'>退出登录</a></td></tr></table></td></tr></table>"
'返回成功登陆信息
Return(strWelcome)
Else
Dim strError As String
strError="<table width='130'align='center'><tr><td>登录失败：<br>1.用户名或密码错误<br>2.此帐号被锁定<br>3.未<a href='../register/Register.asp' target='_blank'>注册</td></tr>"
strError &="<tr><td height='20'><center><a href='javascript:onclick=history.go(-1)'>【返回】</a></center></td></tr></td></tr></table>"
'返回登陆失败信息
Return(strError)
End If
End Function
Public Property UserID As String
Get
UserID=txtUserID.Text
End Get
Set
txtUserID.Text=value
End Set
End Property
'定义UserPassword的属性
Public Property UserPassword As String
Get
UserPassword=txtUserPassword.Text
End Get
Set
txtUserPassword.Text=value
End Set
End property
</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="168">
<tr>
<td>
<asp:label ID="lblLogin" runat="server">
<table width="168" height="60">
<tr>
<td width="63" align="center">用户名：</td>
<td colspan="2" align="left">
<asp:textbox BorderStyle="Groove" Height="20" Width="90px" runat="server" ID="txtUserID" />
<asp:requiredfieldvalidator ControlToValidate="txtUserID" Display="Dynamic" ID="rfdUserID" runat="server" ErrorMessage="<font color=red>*</font>" />
</td>
</tr>
<tr>
<td align="center">密码：</td>
<td colspan="2" align="left">
<asp:textbox BorderStyle="Groove" Height="20" Width="90px" runat="server" TextMode="Password" ID="txtUserPassword" />
<asp:requiredfieldvalidator ControlToValidate="txtUserPassword" Display="Dynamic" ID="rfdPassword" runat="server" ErrorMessage="<font color=red>*</font>" />
</td>
</tr>
<tr align="center">
<td colspan="3"><input name="image" type="image" src="images/form_login.gif" width="40" height="18" border="0">
<img src="images/form_reg.gif" width="40" height="18" border="0">
<img src="images/form_lost.gif" width="60" height="18" border="0"></td>
</tr>
</table>
</asp:label>
<asp:label ID="lblMessage" runat="server">
<table width="100%">
<tr>
<td> </td>
</tr>
</table>
</asp:label>
</td>
</tr>
</table>
