.NET开发

本类阅读TOP10

·NHibernate快速指南(翻译)
·vs.net 2005中文版下载地址收藏
·【小技巧】一个判断session是否过期的小技巧
·VB/ASP 调用 SQL Server 的存储过程
·?dos下编译.net程序找不到csc.exe文件
·通过Web Services上传和下载文件
·学习笔记(补)《.NET框架程序设计(修订版)》--目录
·VB.NET实现DirectDraw9 (2) 动画
·VB.NET实现DirectDraw9 (1) 托管的DDraw
·建站框架规范书之——文件命名

分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
Using OleDb Command

作者:未知 来源:月光软件站 加入时间:2005-5-13 月光软件站

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

'Using OleDb Command
'By:wgscd
'QQ153964481

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

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

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

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

    Public Sub New()
        MyBase.New()

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

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

    End Sub

    '窗体重写 dispose 以清理组件列表。
    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

    '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()
        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(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(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        getDb()

    End Sub
    Dim olead As New OleDbDataAdapter(olecmd)

    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(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(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", "[email protected]")
                olecmd.ExecuteNonQuery()
                oleconn.Close()

            End If

        Catch ex As Exception
            MsgBox(ex.Message)


        End Try

    End Sub
End Class




相关文章

相关软件