Using OleDb Command

'**********************************

'Using OleDb Command
'By:wgscd
'QQ153964481

'*********************************
'先建立一个用ACCACESS建立一个名为“wgscd”的数据库
'字段：编号,电话,地址,QQ,MAIL

'保存路径：C:/me/source_file/wgscd.mdb

'*********************************
Public Class Form1Class Form1
    Inherits System.Windows.Forms.Form

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

    Public Sub New()Sub New()
        MyBase.New()

        '该调用是 Windows 窗体设计器所必需的。
        InitializeComponent()

        '在 InitializeComponent() 调用之后添加任何初始化

    End Sub

    '窗体重写 dispose 以清理组件列表。
    Protected Overloads Overrides Sub Dispose()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

    'Windows 窗体设计器所必需的
    Private components As System.ComponentModel.IContainer

    '注意: 以下过程是 Windows 窗体设计器所必需的
    '可以使用 Windows 窗体设计器修改此过程。
    '不要使用代码编辑器修改它。
    Friend WithEvents Button1 As System.Windows.Forms.Button
    Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid
    Friend WithEvents Button2 As System.Windows.Forms.Button
    Friend WithEvents Button3 As System.Windows.Forms.Button
    Friend WithEvents DataGridTableStyle1 As System.Windows.Forms.DataGridTableStyle
    Friend WithEvents TextBox1 As System.Windows.Forms.TextBox
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()Sub InitializeComponent()
        Me.Button1 = New System.Windows.Forms.Button
        Me.DataGrid1 = New System.Windows.Forms.DataGrid
        Me.DataGridTableStyle1 = New System.Windows.Forms.DataGridTableStyle
        Me.Button2 = New System.Windows.Forms.Button
        Me.Button3 = New System.Windows.Forms.Button
        Me.TextBox1 = New System.Windows.Forms.TextBox
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'Button1
        '
        Me.Button1.Location = New System.Drawing.Point(528, 24)
        Me.Button1.Name = "Button1"
        Me.Button1.Size = New System.Drawing.Size(88, 32)
        Me.Button1.TabIndex = 1
        Me.Button1.Text = "Delete"
        '
        'DataGrid1
        '
        Me.DataGrid1.BackgroundColor = System.Drawing.Color.Tan
        Me.DataGrid1.CaptionText = "oleDb demo   By wgscd"
        Me.DataGrid1.DataMember = ""
        Me.DataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.DataGrid1.Location = New System.Drawing.Point(24, 72)
        Me.DataGrid1.Name = "DataGrid1"
        Me.DataGrid1.Size = New System.Drawing.Size(608, 304)
        Me.DataGrid1.TabIndex = 2
        Me.DataGrid1.TableStyles.AddRange(New System.Windows.Forms.DataGridTableStyle() {Me.DataGridTableStyle1})
        '
        'DataGridTableStyle1
        '
        Me.DataGridTableStyle1.BackColor = System.Drawing.Color.Blue
        Me.DataGridTableStyle1.DataGrid = Me.DataGrid1
        Me.DataGridTableStyle1.HeaderBackColor = System.Drawing.Color.FromArgb(CType(128, Byte), CType(255, Byte), CType(255, Byte))
        Me.DataGridTableStyle1.HeaderFont = New System.Drawing.Font("宋体", 12.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte))
        Me.DataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.DataGridTableStyle1.LinkColor = System.Drawing.Color.RosyBrown
        Me.DataGridTableStyle1.MappingName = ""
        Me.DataGridTableStyle1.SelectionBackColor = System.Drawing.Color.FromArgb(CType(255, Byte), CType(192, Byte), CType(255, Byte))
        '
        'Button2
        '
        Me.Button2.Location = New System.Drawing.Point(40, 16)
        Me.Button2.Name = "Button2"
        Me.Button2.Size = New System.Drawing.Size(88, 32)
        Me.Button2.TabIndex = 3
        Me.Button2.Text = "add new row"
        '
        'Button3
        '
        Me.Button3.Location = New System.Drawing.Point(160, 16)
        Me.Button3.Name = "Button3"
        Me.Button3.Size = New System.Drawing.Size(152, 32)
        Me.Button3.TabIndex = 4
        Me.Button3.Text = "insert command "
        '
        'TextBox1
        '
        Me.TextBox1.Location = New System.Drawing.Point(440, 32)
        Me.TextBox1.Name = "TextBox1"
        Me.TextBox1.Size = New System.Drawing.Size(72, 21)
        Me.TextBox1.TabIndex = 5
        Me.TextBox1.Text = "TextBox1"
        '
        'Form1
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.BackColor = System.Drawing.Color.FromArgb(CType(255, Byte), CType(224, Byte), CType(192, Byte))
        Me.ClientSize = New System.Drawing.Size(696, 430)
        Me.Controls.Add(Me.TextBox1)
        Me.Controls.Add(Me.Button3)
        Me.Controls.Add(Me.Button2)
        Me.Controls.Add(Me.DataGrid1)
        Me.Controls.Add(Me.Button1)
        Me.Name = "Form1"
        Me.Text = "Form1"
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub

#End Region

    Dim strconn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/me/source_file/wgscd.mdb"
    Dim ds As New DataSet("ds")
    Dim dt As New DataTable("tb")
    Dim oleconn As New OleDbConnection(strconn)
    Dim olecmd As New OleDbCommand("select * from 美女联系方式", oleconn) '女名单") '

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


        Try

            If oleconn.State = ConnectionState.Open Then

                If CInt(TextBox1.Text) > 0 Then


                    olecmd.CommandText = "delete from 美女联系方式 where id=" & TextBox1.Text
                    olecmd.ExecuteNonQuery()
                    oleconn.Close()
                    MsgBox("ID为" & TextBox1.Text & "的记录成功删除！")
                    '  Me.DataGrid1 = Nothing

                    '  Me.DataGrid1.Refresh()



                End If

            Else

            End If

            getDb()

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
    End Sub

    Private Sub Form1_Load()Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        getDb()

    End Sub
    Dim olead As New OleDbDataAdapter(olecmd)

    Sub getDb()Sub getDb()

        Try

            oleconn.Open()
            olead.Fill(ds)
            dt = ds.Tables(0)
            DataGrid1.DataSource = dt
            TextBox1.Text = dt.Rows.Count

        Catch ex As Exception

            MsgBox(ex.Message)

        End Try

    End Sub

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

        Dim dr As DataRow = dt.NewRow
        dr(0) = "999"
        dr(1) = "77"
        dr(2) = " 0407"
        dr(3) = "767"
        dr(4) = "737"
        dr(5) = "737"
        dt.Rows.Add(dr)
        dt.AcceptChanges()
        ds.AcceptChanges()

    End Sub

    Private Sub Button3_Click()Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click


        Try

            If oleconn.State = ConnectionState.Open Then
                '添加记录命令串
                olecmd.CommandText = "insert into 美女联系方式 (编号,电话,地址, QQ,MAIL) values (@tid,@phone,@addr,@qq,@mail)"
                olecmd.Parameters.Add("@tid", "66")
                olecmd.Parameters.Add("@phone", "665454").DbType = DbType.String
                olecmd.Parameters.Add("@addr", "swust")
                olecmd.Parameters.Add("@qq", "355566")
                olecmd.Parameters.Add("@mail", "wgscd@sina.com")
                olecmd.ExecuteNonQuery()
                oleconn.Close()

            End If

        Catch ex As Exception
            MsgBox(ex.Message)


        End Try



    End Sub
End Class