string[,] str_arr = new string[,] { {"a","a"}, {"b","b"}, {"c","c"}, {"d","d"} }; StringBuilder _sql_col = new StringBuilder(""); StringBuilder _value_col = new StringBuilder(""); for (int i = 0; i < str_arr.GetUpperBound(0) + 1; i++) { _sql_col.Append("," + str_arr[i, 0].ToString()); _value_col.Append("," + str_arr[i, 1].ToString()); } string _sql = "insert into test (" + _sql_col.ToString() + ") select " + _value_col.ToString() + " from test2 where ID = " + tid.Value.Trim();
c# 多维数组的使用
最新推荐文章于 2025-08-09 22:19:42 发布