C# DataTable 行转列
1 #region 根据datatable获得列名 2 ///3 /// 根据datatable获得列名 4 /// 5 /// 表对象 6 /// 返回结果的数据列数组 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 }
搞定!