logon.aspx.vb

这是一个电子商务入门级的代码。 其中包括用户注册

Imports System.Data
Imports System.Data.OleDb
Public Class WebForm1
    Inherits System.Web.UI.Page
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents RadioButtonList1 As System.Web.UI.WebControls.RadioButtonList
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label
    Protected WithEvents Label3 As System.Web.UI.WebControls.Label
    Protected WithEvents Label4 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
    Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Button3 As System.Web.UI.WebControls.Button
    Protected WithEvents Button2 As System.Web.UI.WebControls.Button

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

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

    End Sub

    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
        If Not IsPostBack Then
            RadioButtonList1.SelectedIndex = 0
        End If
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        If TextBox1.Text = "" Or TextBox2.Text = "" Then
            Response.Write("<script language=vbscript>alert ""请输入完整信息后再提交!""</script>")
        Else
            Dim conn As New OleDbConnection()
            Dim cmd As New OleDbCommand()
            Dim reader As OleDbDataReader

            conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("OnLineSale.mdb")
            conn.Open()
            cmd.Connection = conn
            cmd.CommandType = CommandType.Text
            If RadioButtonList1.SelectedIndex = 0 Then
                cmd.CommandText = "select * from customer where cusID='" & TextBox1.Text & _
                                  "'and pwd='" & TextBox2.Text & "'"
            Else
                cmd.CommandText = "select * from manager where managerID='" & TextBox1.Text & _
                                                  "'and pwd='" & TextBox2.Text & "'"
            End If

            reader = cmd.ExecuteReader()
            If reader.Read = False Then
                Response.Write("<script language=vbscript>alert ""帐号或密码有误!""</script>")
            Else 
                If RadioButtonList1.SelectedIndex = 0 Then
                    Session("cusID") = reader("cusID")
                    Response.Redirect("buy.aspx")
                Else
                    Response.Redirect("managerOption.aspx")
                    Session("managerID") = reader("managerID")
                End If

            End If

            conn.Close()
            conn = Nothing
        End If
    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        Response.Redirect("regNew.aspx")
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        TextBox1.Text = ""
        TextBox2.Text = ""
    End Sub
End Class