- C# code
sql += ") values('"; int j = 0; foreach (Field unfield in fieldArray) { if (!unfield.Value.Equals(String.Empty)) { sql += unfield.Value; if (j < 5) { sql += "','"; } j++; } } sql += "');";
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') values('sdsdsds','dsd','sdsdsd','sd','')' at line 1
为什么上面会这样呢..
我上面注册页面只要输入五个值,然后值存放在一个自己写的Field里,要把5个Field放入ArrayList里,可是为什么执行完后会多出",''"这个字符串呀,,请大家帮帮忙呀??
------解决方案--------------------------------------------------------
改成这样试试 还不行 只能跟踪调式了 这样改改应该可以了
- C# code
sql += ") values('"; int j = 0; foreach (Field unfield in fieldArray) { j++; if (!unfield.Value.Equals(String.Empty)) { sql += unfield.Value; if (j < 5) { sql += "','"; } } } sql += "');";