login.aspx.vb

此系统是一会员管理系统

Imports System.Data
Imports System.Data.sqlclient
Imports System.Web.Security








Public Class login
    Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents userid As System.Web.UI.WebControls.TextBox
    Protected WithEvents userpwd As System.Web.UI.WebControls.TextBox
    Protected WithEvents savepwd As System.Web.UI.WebControls.CheckBox
    Protected WithEvents enter As System.Web.UI.WebControls.Button
    Protected WithEvents errmessage As System.Web.UI.WebControls.Label

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
    End Sub

    Private Sub enter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles enter.Click

        Dim objconn As sqlConnection
        objconn = New SqlConnection("server=BBS-HZ0752-NET;uid=sa;pwd=1228;database=xiangdaoyu")
        objconn.Open()
        Dim objcmd As New SqlCommand

        objcmd.Connection = objconn
        objcmd.CommandText = "select * from xiangdaoyu where 帐号 like '" & userid.Text & "' and 密码 like'" & userpwd.Text & "'"
        '创建datareader对象
        Dim objreader As SqlDataReader = objcmd.ExecuteReader()
        '判断是否通过验证
        If objreader.Read() = True Then
            FormsAuthentication.SetAuthCookie(userid.Text, savepwd.Checked)


            Response.Redirect("default.aspx")
        Else
            errmessage.Text = "帐号或密码错误，请重新输入"

        End If
        objreader.Close()
        objconn.Close()


    End Sub
End Class