修改密码.vb

来自「银行帐户管理系统」· VB 代码 · 共 39 行

Public Class 修改密码
    Inherits System.Windows.Forms.Form
    Dim strconn As String = "data source=.;initial catalog=weboy;user id=sa;password=;"
    Dim objds As New Data.DataSet
    Dim objda As SqlClient.SqlDataAdapter
    Dim bingpage As BindingManagerBase
    Dim cn As New SqlClient.SqlConnection
    Dim cmd As SqlClient.SqlCommand

    Private Sub 修改密码_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 sql As String
        sql = "update users set password='" & Trim(MaskedTextBox2.Text) & "'where password ='" & Trim(MaskedTextBox1.Text) & "'"
        'sql = "updata users  set password='" & Trim(MaskedTextBox2.Text) & "'  where 用户初始密码 = '" & Trim(MaskedTextBox1.Text) & "'"
        cn.ConnectionString = strconn
        cn.Open()
        cmd = New SqlClient.SqlCommand(sql, cn)
        cmd.ExecuteNonQuery()
        cmd.Dispose()
        cn.Dispose()
        MessageBox.Show("更改成功！", "恭喜！", MessageBoxButtons.OK, MessageBoxIcon.Information)
        MaskedTextBox1.Text = ""
        MaskedTextBox2.Text = ""
        MaskedTextBox3.Text = ""
    End Sub
    

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        
        Me.Close()


        'MaskedTextBox1.Text = ""
        'MaskedTextBox2.Text = ""
        'MaskedTextBox1.Focus()
    End Sub
End Class