Question

sql "')' 附近有语法错误

string sql = "insert into PotatoMiao (PotatoName,bozhongqi,chumiaoqi,chumiaolv,xianleiqi,kaihuaqi,chengshuqi,shengyutianshu,jingyanse,yeyanse,huaguanse,huafanmaoxing,tianranjieshixing,MiaoPuID,PotatoImage)";
sql += "values('{0}','{1}','{2}','{3}','{4}','{5}','{6}',{7},'{8}','{9}','{10}','{11}','{12}',{13},'{14}',)";
sql = string.Format(sql,objPotatoMiao.PotatoName,objPotatoMiao.bozhongqi,objPotatoMiao.chumiaoqi,objPotatoMiao.chumiaolv,objPotatoMiao.xianleiqi,objPotatoMiao.kaihuaqi,objPotatoMiao.chengshuqi,objPotatoMiao.shengyutianshu,objPotatoMiao.jingyanse,objPotatoMiao.yeyanse, objPotatoMiao.huaguanse,objPotatoMiao.huafanmaoxing,objPotatoMiao.tianranjieshixing,objPotatoMiao.MiaoPuID,objPotatoMiao.PotatoImage);
不知道哪里错了 求大神啊

Answer 1

"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}',{7},'{8}','{9}','{10}','{11}','{12}',{13},'{14}',)";
最后是不是多了个“，”？

Answer 2

这里加个空格,后面多了个逗号
sql += " values('{0}','{1}','{2}','{3}','{4}','{5}','{6}',{7},'{8}','{9}','{10}','{11}','{12}',{13},'{14}' )";