Partial Class _Default Inherits System.Web.UI.Page Protected Sub Login1_Authenticate(ByVal

版权声明: https://blog.csdn.net/eds124/article/details/86665142

Partial Class _Default
    Inherits System.Web.UI.Page

    Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate
        Dim username As String = Me.Login1.UserName
        Dim userpass As String = Me.Login1.Password
        Dim b As Boolean = Me.Login1.RememberMeSet


        Using sds As SqlDataSource = New SqlDataSource("Data Source=.;Initial Catalog=master;Integrated Security=True", "select count(*) from t_user where username = @username and userpass = @userpass")
            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
        End Using

        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
End Class

展开阅读全文

没有更多推荐了,返回首页