VB 2010 Express连接到microsoft 2010数据库

Question

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Try
        Dim sqlquery As String = "INSERT INTO Table1(Customer Name,Address,Contact Number,Type Of Customer)VALUES('" & TextBox1.Text & "', '" & TextBox2.Text & "', '" & TextBox3.Text & "','" & TextBox4.Text & "')"

        Dim sqlcommand As New OleDbCommand

        With sqlcommand
            .CommandText = sqlquery
            .Connection = con
            .ExecuteNonQuery()
        End With
        MsgBox("ONE RECORD SUCCESFULLY ADDED :)")

    Catch ex As Exception
        MsgBox(ex.ToString)

    End Try
End Sub

有人能帮我吗？它说插入语句中有错误，我不知道为什么。谢谢你的帮助。

Answer 1

尝试在包含空格的列名周围放置[]。

(客户姓名、地址、联系电话、客户类型)

Answer 2

当字段中有空格时，必须将字段包含在字段中，否则它会将其视为两个字段并搜索分隔符，在本例中没有分隔符。

希望我的答案能有所帮助。