form2.vb

Visual Basic.net 实例入门

Public Class deletewindow
    Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents yourname As System.Windows.Forms.TextBox
    Friend WithEvents m_delete As System.Windows.Forms.Button
    Friend WithEvents Label2 As System.Windows.Forms.Label

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.Container

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.Label1 = New System.Windows.Forms.Label()
        Me.yourname = New System.Windows.Forms.TextBox()
        Me.Label2 = New System.Windows.Forms.Label()
        Me.m_delete = New System.Windows.Forms.Button()
        Me.SuspendLayout()
        '
        'Label1
        '
        Me.Label1.Location = New System.Drawing.Point(51, 16)
        Me.Label1.Name = "Label1"
        Me.Label1.Size = New System.Drawing.Size(56, 16)
        Me.Label1.TabIndex = 1
        Me.Label1.Text = "姓名："
        '
        'yourname
        '
        Me.yourname.Location = New System.Drawing.Point(112, 8)
        Me.yourname.Name = "yourname"
        Me.yourname.TabIndex = 2
        Me.yourname.Text = ""
        '
        'Label2
        '
        Me.Label2.Location = New System.Drawing.Point(72, 48)
        Me.Label2.Name = "Label2"
        Me.Label2.Size = New System.Drawing.Size(165, 16)
        Me.Label2.TabIndex = 3
        Me.Label2.Text = "请输入要删除记录中的姓名。"
        '
        'm_delete
        '
        Me.m_delete.Location = New System.Drawing.Point(96, 80)
        Me.m_delete.Name = "m_delete"
        Me.m_delete.TabIndex = 0
        Me.m_delete.Text = "删除"
        '
        'deletewindow
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(292, 123)
        Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.Label2, Me.yourname, Me.Label1, Me.m_delete})
        Me.MaximizeBox = False
        Me.MinimizeBox = False
        Me.Name = "deletewindow"
        Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen
        Me.Text = "删除记录"
        Me.ResumeLayout(False)

    End Sub

#End Region

    Private Sub yourname_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles yourname.TextChanged

    End Sub

    Private Sub m_delete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles m_delete.Click
        If yourname.Text = "" Then '判断输入的姓名是否有效
            Label2.Text = "姓名不能为空！"
        Else
            Dim mainform As New personal.m_main()

            mainform.OleDbCommand1.CommandText = "delete from txl where yourname='" + yourname.Text + "'"
            mainform.OleDbConnection1.Open() '打开连接
            mainform.OleDbCommand1.ExecuteNonQuery() '删除记录
            Me.Close() '关闭连接
        End If
    End Sub
End Class