数据库插入的问题(菜鸟级)
做了一个数据库插入的函数
执行不了
望各位大侠帮忙
Public Function UpdateDB(ByVal sqlStr As String) As Boolean
Dim sqlconn As New OleDbConnection(connectStr)
Try
Dim cmdTable As OleDbCommand = New OleDbCommand(sqlStr, sqlconn)
cmdTable.CommandType = CommandType.Text
sqlconn.Open()
cmdTable.ExecuteNonQuery()
sqlconn.Close()
Catch ex As Exception
MessageBox.Show(Err.Description)
End Try
Return True
End Function
值取到了
但是到cmdTable.ExecuteNonQuery()就说 Insert into语句语法错误
希不吝赐教