UC知道asp.net access添加记录出现的问题(VB)
来源：百度知道 编辑：UC知道 时间：2024/05/30 02:04:11
System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
源错误:
行 28： myCommand = New OleDb.OleDbCommand(sql, conn)
行 29：
行 30： myCommand.ExecuteNonQuery()
行 31： ' La2.Text = "New Record Inserted!"
行 32： '在此处放置初始化页的用户代码
具体代码为： Dim conn As OleDb.OleDbConnection
Dim myCommand As OleDb.OleDbCommand
Dim connstr As String
Dim sql As String
Dim myread As OleDb.OleDbDataReader
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim dbname As String
dbname = Server.MapPath("aa.mdb")
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbname
conn = New OleDb.OleDbConnection(connstr)
conn.Open()
La1.Text = "Connection Opened!"
sql = "insert into us
源错误:
行 28： myCommand = New OleDb.OleDbCommand(sql, conn)
行 29：
行 30： myCommand.ExecuteNonQuery()
行 31： ' La2.Text = "New Record Inserted!"
行 32： '在此处放置初始化页的用户代码
具体代码为： Dim conn As OleDb.OleDbConnection
Dim myCommand As OleDb.OleDbCommand
Dim connstr As String
Dim sql As String
Dim myread As OleDb.OleDbDataReader
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim dbname As String
dbname = Server.MapPath("aa.mdb")
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbname
conn = New OleDb.OleDbConnection(connstr)
conn.Open()
La1.Text = "Connection Opened!"
sql = "insert into us
sql = "insert into user(nameid,password)values('Simson','000')"
在values前面加个空格,把user和password加上中括号，可能是user或者password与内置对象重名
sql = "insert into [user](nameid,[password]) values('Simson','000')"