http://localhost:49330/WebSite/Default.aspx.vb最终版

Partial Class _Default
    Inherits System.Web.UI.Page

    Private sds As SqlDataSource = New SqlDataSource()

    Public Sub New()
        Me.sds.ProviderName = "System.Data.Odbc"
        Me.sds.ConnectionString = "Dsn=mydata"
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Request.Cookies("username") Is Nothing Or Request.Cookies("userpass") Is Nothing Then '没有就不执行
            Return
        End If

        Me.sds.SelectCommand = "select count(*) from t_user where username = ? and userpass = ?"
        Me.sds.SelectParameters.Add(1, Request.Cookies("username").Value)
        Me.sds.SelectParameters.Add(2, Request.Cookies("userpass").Value)

        Dim dv As System.Data.DataView = sds.Select(DataSourceSelectArguments.Empty)
        If dv(0)(0) = 0 Then
            Return
        End If

        Response.Redirect("~/Index.aspx")
    End Sub

    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

        Me.sds.SelectCommand = "select count(*) from t_user where username = ? and userpass = ?"
        Me.sds.SelectParameters.Add(1, username)
        Me.sds.SelectParameters.Add(2, userpass)

        Dim dv As System.Data.DataView = Me.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 Me.Login1.RememberMeSet 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