VB连接access数据库

来源:互联网 发布:linux删除空文件夹 编辑:程序博客网 时间:2024/05/01 23:53
Imports System.Data.OleDbPublic Class InsertTest    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click        Dim oledb1 As New OleDbConnection        oledb1.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\liang.accdb"        oledb1.Open()        If ConnectionState.Open Then            Dim cmd1 As New OleDbCommand            cmd1.Connection = oledb1            cmd1.CommandText = "Insert into 借书人(姓名,电话)values('" + TextBox1.Text + "'" + ",'" + TextBox2.Text + "')"            cmd1.ExecuteNonQuery()            oledb1.Close()        End If    End SubEnd Class

注意:以下黄色区两边的是双引号

 "Insert into 借书人(姓名,电话)values('" + TextBox1.Text + "'" + ",'" + TextBox2.Text + "')"



0 0
原创粉丝点击