http://localhost:49431/WebSite/Default.aspx单文件前台不拖一个控件-CSDN博客

本文链接：https://blog.csdn.net/eds124/article/details/86748993

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">

    Private WithEvents l As Login = New Login()
    Private Shared ReadOnly ConnectionString As String = ConfigurationManager.ConnectionStrings("mydata").ConnectionString
    Private sds As SqlDataSource = New SqlDataSource(ConnectionString, "select count(*) from t_user where username = @username and userpass = @userpass")
    
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
        form1.Controls.Add(l)
    End Sub
    
    Private Sub la(ByVal o As Object, ByVal aea As 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
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    </div>
    </form>
</body>
</html>