110,538
社区成员
发帖
与我相关
我的任务
分享
string sql = string.Format(" select {0},{1}",
"aaa",
CreateGeItemNullNameSql()
);
private string CreateGeItemNullNameSql()
{
string sql = string.Empty;
for (int i = 1; i <= 20; i++)
{
if(!string.IsNullOrEmpty(sql))
{
sql+=",";
}
sql += string.Format(" NULL AS {0}, NULL AS {1}, NULL AS {2} ",
"ITEMNO"+i,
"ITEMNAME" + i,
"VALUE" + i
);
}
return sql;
}
接楼上所说,报错是因为少个','
多个字符串拼接,可以使用stringbuilder提高效率