27,581
社区成员




int L = 9;
string[] Alps = new string[L]; //对应字母
string[] nums = new string[L]; //数值
var sql = string.Join(",", Alps);
var paras = new List<SqlParameter>();
for (var i = 0; i < 9; i++)
{
paras.Add(new SqlParameter(Alps[i], nums[i]));
Alps[i] = "@" + Alps[i];
}
sql = "Insert Into SomeTable (" + sql + ") values (" + string.Join(",", Alps) + ")";
using (SqlConnection conn = new SqlConnection("连接字符串"))
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddRange(paras.ToArray());
cmd.ExecuteNonQuery();
}