http://localhost:53019/WebSite/Default.aspx.vb

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 conn As System.Data.Odbc.OdbcConnection = New System.Data.Odbc.OdbcConnection("dsn=mydata")
            Using comm As System.Data.Odbc.OdbcCommand = New System.Data.Odbc.OdbcCommand("select count(*) from t_user where username = ? and userpass = ?", conn)
                comm.Parameters.AddWithValue(1, username)
                comm.Parameters.AddWithValue(2, userpass)
                conn.Open()
                If comm.ExecuteScalar() = 0 Then
                    Return
                End If
            End Using
        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