memberreg.aspx.vb

后台管理 内容添加功能

Imports System.Data.OleDb


Namespace DotNet2000

Partial Class MemberReg
    Inherits System.Web.UI.Page

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

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

    End Sub

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

    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 RegCmd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RegCmd.Click
        Dim Conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DbPath))
        Dim SqlStr As String = "select * from MemberInfo where UserName='" & Trim(UserName.Text) & "'"
        Dim SqlCommand As New OleDbCommand(SqlStr, Conn)
        Conn.Open()

        Dim Rs As OleDbDataReader = SqlCommand.ExecuteReader
        Dim FoundRs As Boolean
        FoundRs = False
        While Rs.Read()
            FoundRs = True
        End While
        Rs.Close()
        SqlCommand.ExecuteReader.Close()

        If FoundRs = False Then
            SqlStr = "insert into MemberInfo (username,passwordstr,email,QQ,birthday,QuestionStr,AnsStr) values ('" & UserName.Text & "','" & RePassword.Text & "','" & EMail.Text & "','" & QQ.Text & "','" & Birthday.Text & "','" & QuestionStr.Text & "','" & AnsStr.Text & "')"
            SqlCommand = New OleDbCommand(SqlStr, Conn)
            SqlCommand.ExecuteNonQuery()
            Response.Redirect("MsgBox.aspx?Msg=01T")
        Else
            Response.Redirect("MsgBox.aspx?Msg=01F")
        End If

        Rs.Close()
        Conn.Close()
    End Sub

    Private Sub YesCmd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles YesCmd.Click
        Step1.Visible = False
        Step2.Visible = True
    End Sub

    Private Sub NoCmd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NoCmd.Click
        Response.Redirect("index.aspx")
    End Sub
End Class

End Namespace