C# DataTable 行转列

 1   #region 根据datatable获得列名
 2         /// <summary>
 3         /// 根据datatable获得列名
 4         /// </summary>
 5         /// <param name="dt">表对象</param>
 6         /// <returns>返回结果的数据列数组</returns>
 7         public static string[] GetColumnsByDataTable(DataTable dt)
 8         {
 9             string[] strColumns = null;
10 
11 
12             if (dt.Columns.Count > 0)
13             {
14                 int columnNum = 0;
15                 columnNum = dt.Columns.Count;
16                 strColumns = new string[columnNum];
17                 for (int i = 0; i < dt.Columns.Count; i++)
18                 {
19                     strColumns[i] = dt.Columns[i].ColumnName;
20                 }
21             }
22             return strColumns;
23         }
24         #endregion
1  for (int i = 0; i < name.Length; i++)
2 {
3      dtColumn.Rows.Add(new string[] { "0", name[i], "" });
4 }

搞定!