怎么这样老是出错?
Dim ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.mappath("products.mdb")
Dim MyConn As OleDb.OleDbConnection = New OleDb.OleDbConnection(ConStr)
MyConn.Open()
Dim SqlStr As String = "insert into products (listtypeid, isclass, isshow, allc, memo) values (1,True,True,True,'afsdfasdf')"
Dim ExeCom As New OleDb.OleDbCommand(SqlStr, MyConn)
ExeCom.ExecuteNonQuery()
上面这段程序,在运行的时候老是报错,出错提示是Insert Into 语法错误,但同样的数据表,同样的程序,在Sql Server里运行正常。。。
这是为什么???
郁闷中。。。