62,243
社区成员




string table = "";
string value = "";
SqlParameter[] paras = null;
List<SqlParameter> paraList = new List<SqlParameter>();
int i = 0;
foreach (var v in values)
{
if (i != values.Keys.Count - 1)
{
table += "[" + v.Key + "], ";
value += "'" + v.Value + "',";
}
else
{
table += "[" + v.Key + "]";
value += "" + v.Value;
}
paraList.Add(new SqlParameter("@" + v.Key + "", "" + v.Value + ""));
i++;
}
insert into tableName([Aa], [Bb], [Cc], [Dd]) values('a','b','c','d',) 这个地方最后怎么去掉这个逗号????