添加用户.vb

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

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 Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Me.Close()
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim ssssql As String

        ssssql = "insert into users(password,name,power) values('" & Trim(MaskedTextBox1.Text) & "','" & Trim(MaskedTextBox2.Text) & "','" & Trim(ComboBox1.Text) & "')"
        'ssssql = "insert into users(password,name,power) values('" & Trim(MaskedTextBox1.Text) & "','" & Trim(MaskedTextBox2.Text) & "','" & Trim(ComboBox1.Text) & "')"
        cn.ConnectionString = strconn
        cn.Open()
        cmd = New SqlClient.SqlCommand(ssssql, cn)
        cmd.ExecuteNonQuery()
        cmd.Dispose()
        cn.Dispose()
        MaskedTextBox1.Text = ""
        MaskedTextBox2.Text = ""
        
        MessageBox.Show("添加成功！", "恭喜！", MessageBoxButtons.OK, MessageBoxIcon.Information)

        Me.Close()
    End Sub

    Private Sub 添加用户_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    End Sub
End Class