实在不明白这么写错在何处?Insert into的问题
源码如下:
dim provider,SQL,ConnStr as string
provider="Microsoft.Jet.OLEDB.4.0;"
ConnStr = "Provider="+Provider+"Data Source="+Server.MapPath( "/db/PurchaseInfo.mdb" )+";Persist Security Info=False;User ID=;Jet OLEDB:Database password=123"
SQL="select * from price"
dim cm as new oledbcommand()
dim con as new oledbconnection()
con.connectionstring=ConnStr
dim cmd as oledbDataAdapter
cmd=new OLEDbDataAdapter(SQL,Connstr)
dim ds as dataset=new dataset()
cmd.fill(ds,"price")
dim dt as DataTable=ds.tables("price")
con.open()
cm.connection=con
cm.commandtext="insert into price(ID,名称,材料类型,材质,规格型号,单位,单价,单价是否含运费,购买时间,现/期货,付款条件,供应方式,执行标准,产地,购买单位,用途,供应商名称,供应商电话,备注) values('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s')"
cm.ExecuteNonQuery()
con.close
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
运行后提示“System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。”
cm.ExecuteNonQuery()这句变红
我用的是Access数据库
请大虾指点!!
附上Stack Trace
[OleDbException (0x80040e14): INSERT INTO 语句的语法错误。]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +174
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +66
ASP.Purchase_Add_aspx.btnAdd_click(Object sender, EventArgs e) in E:\platform\Purchase_Add.aspx:57
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277