Question

c#中错误显示常量中有换行符怎么回事，，求改正后正确答案

string sql = " update tb_library set libraryName=" + libraryName + ",curator=" + curator + ",tel=" + tel + ",address=" + address + ",email=" + email + ",net=" +
net + ",upbuildTime=" + upbuildTime + ",remark=" + remark + " ";
按照回答改了几次之后，问题就更大了，变成这样了！

Answer 1

不要换行，这句应该是没有问题的。你是在这里报错的么，还是操作数据库的时候报错的，因为你上面写的这句代码应该没有问题的

追问

是调试的时候出现的问题！

追答

额，你老人家得先定义这些变量好吧，变量不是常量，你不先定义是不会天上掉下来的
string libraryName = "";
string curator = "";
string tel = "";
string address = "";
string email = "";
string net = "";
string upbuildTime = "";
string remark = "";
string sql = " update tb_library set libraryName=" + libraryName + ",curator=" + curator + ",tel=" + tel + ",address=" + address + ",email=" + email + ",net=" + net + ",upbuildTime=" + upbuildTime + ",remark=" + remark + " ";

Answer 2

string sql = @" update tb_library set libraryName=" + libraryName + ",curator=" + curator + ",tel=" + tel + ",address=" + address + ",email=" + email + ",net=" +
net + ",upbuildTime=" + upbuildTime + ",remark=" + remark + " ";

Answer 3

sb.AppendLine("TRUNCATE TABLE jzpwd ");
sb.AppendFormat(" UPDATE USERID SET boolean = 1 WHERE name = '{0}' ", name);
用StringBuilder
你可能前面没有队变量赋初始值

Answer 4

这句代码你要写在一行上，而不可以回车。