Question

c#提示“insert into”语法错误，求解

string ordernum,string snum,string state,string time,string processcontinue,string processtype,string backtime,string rework,string recover
。。。
string sql = string.Format("insert into tableinfo(ordernum, snum, state, time, processcontinue, processtype, backtime, rework, recover) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", ordernum, snum, state, time, processcontinue, processtype, backtime, rework, recover);

Answer 1

如果这几个字段里有单引号，这种拼串的方式会导致错误。
具体错误信息是什么？贴出来看看

Answer 2

'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}' 去掉引号