searchpwd.aspx.vb

此系统是一会员管理系统

Imports System.Data
Imports System.Data.sqlclient
Imports System.Web.mail
Public Class searchpwd
    Inherits System.Web.UI.Page

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

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

    End Sub
    Protected WithEvents message As System.Web.UI.WebControls.Label
    Protected WithEvents username As System.Web.UI.WebControls.TextBox
    Protected WithEvents showmethod As System.Web.UI.WebControls.RadioButtonList
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents email As System.Web.UI.WebControls.TextBox

    '注意: 以下占位符声明是 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 Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.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'" & username.Text & "'and  邮件帐号 like '" & email.Text & "'"
        Dim objreader As SqlDataReader = objcmd.ExecuteReader()
        '判断指定的姓名及邮件帐号是否存在
        If objreader.Read = True Then
            If showmethod.SelectedItem.Text = "网页显示" Then
                message.Text = "您的帐号为：" & objreader.Item("帐号") & "<br> " & "您的密码为;" & objreader.Item("密码") & " <a href='/xiangdaoyu2/login.aspx'>登录本站</a>"

            Else
                Dim objmail As New MailMessage

                objmail.From = "系统管理者<[e-mail]>"
                objmail.To = username.Text & "<" & email.Text & ">"
                objmail.Subject = "ASP.NET网络世界登录帐号与密码"
                objmail.Body = "您的帐号为：" & objreader.Item("帐号") & Chr(10) & "您的密码为:" & objreader.Item("密码")
                SmtpMail.SmtpServer = "send.net.tw"
                SmtpMail.Send(objmail)
                message.Text = "您的帐号及密码已经寄到" & email.Text & "信箱了。"
            End If
        Else
            message.Text = "对不起，本站没有此会员，请确定您查询的数据是正确的。"
        End If
        objreader.Close()
        objconn.Close()

    End Sub
End Class