导入DataTable

Question

string aa ="asd|asd|asd|asd|asdasd|asad|asd|asd|asd|asd|asdasd|asad|asd|asd|asd|asd|asdasd|asad";有个这样的字符串 怎么才能导入到一个六列的DataTable中呢 字符串的个数始终都是6的倍数

Answer 1

string[] tmpStrArr = tmpStr.Split('|');
            DataTable dt = new DataTable();
            int colCount = 6;
            for (int i = 0; i < colCount; i++) {
                dt.Columns.Add(new DataColumn("col"+i.ToString(), typeof(string)));
            }
            for (int i = 0; i < tmpStrArr.Length / colCount; i++)
            {
                string[] tmpArr = new string[colCount];
                Array.Copy(tmpStrArr, i * colCount, tmpArr, 0, colCount);
                dt.Rows.Add(tmpArr);
            }