不好意思: bianma 文本 wenzhi 文本 number 数字 '"+m+"' 改为 "+m+"也还是一样 抛出的错误: "Failed to connect to data sourceSystem.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)\r\n at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()\r\n at excelExport.Form1.button2_Click(Object sender, EventArgs e) in f:\\参考代码\\excelexport\\excelexport\\form1.cs:line 214"
try:string str="insert into Zi1jm([BIANMA],[WENZHI],[NUMBER]) values('"+b+"','"+z+"','"+m+"')";
分别是什么类型?
bianma 文本
wenzhi 文本
number 数字
'"+m+"' 改为 "+m+"也还是一样
抛出的错误:
"Failed to connect to data sourceSystem.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)\r\n at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)\r\n at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()\r\n at excelExport.Form1.button2_Click(Object sender, EventArgs e) in f:\\参考代码\\excelexport\\excelexport\\form1.cs:line 214"