Partial Class _Default
Inherits System.Web.UI.Page
Private WithEvents l As Login = New Login()
Private Shared ReadOnly ConnectionString As String = ConfigurationManager.ConnectionStrings("mydata").ConnectionString
'Public Shared ReadOnly ConnectionString As String = "Data Source=.;Initial Catalog=master;Integrated Security=True"
Private sds As SqlDataSource = New SqlDataSource(ConnectionString, "select count(*) from t_user where username = @username and userpass = @userpass")
Protected Sub l_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles l.Authenticate
Dim username As String = Me.l.UserName
Dim userpass As String = Me.l.Password
Dim b As Boolean = Me.l.RememberMeSet
sds.SelectParameters.Add("username", username) '预处理
sds.SelectParameters.Add("userpass", userpass)
Dim dv As System.Data.DataView = sds.Select(DataSourceSelectArguments.Empty)
If dv(0)(0) = 0 Then
Return
End If
Response.Cookies("username").Value = username '登录成功写入cookie
Response.Cookies("userpass").Value = userpass
If b Then
Response.Cookies("username").Expires = DateTime.Now.AddDays(7) '设置cookie超时时间为7天
Response.Cookies("userpass").Expires = DateTime.Now.AddDays(7)
End If
Response.Redirect("~/Index.aspx") '登录成功跳转
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Me.form1.Controls.Add(l)
End Sub
End Class
http://localhost:49431/WebSite/Default.aspx.vb
最新推荐文章于 2023-12-07 17:53:58 发布