csharp: datatable get Column datatype or Column Name

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76

/// <summary>         ///列表名         /// </summary>         /// <param name="table"></param>         /// <returns></returns>         public static string GetColumnNames(System.Data.DataTable table)         {             if (table != null)             {                 List<string> lstColumn = new List<string>();                   foreach (System.Data.DataColumn col in table.Columns)                 {                     lstColumn.Add(col.ColumnName);                 }                   return String.Join(",", lstColumn.ToArray());             }               return string.Empty;             //foreach (DataRow row in table.Rows)             //{             //    foreach (DataColumn column in table.Columns)             //    {             //        ColumnName = column.ColumnName;             //        ColumnData = row[column].ToString();             //    }             //}         }         /// <summary>         /// 数据类型         /// </summary>         /// <param name="table"></param>         /// <returns></returns>         public static string GetColumnNamesType(System.Data.DataTable table)         {             if (table != null)             {                 List<string> lstColumn = new List<string>();                   foreach (System.Data.DataColumn col in table.Columns)                 {                     lstColumn.Add(table.Columns[col.ColumnName].DataType.ToString());                 }                   return String.Join(",", lstColumn.ToArray());             }               return string.Empty;                       }           /// <summary>         /// 列名和数据类型         /// </summary>         /// <param name="table"></param>         /// <returns></returns>         public static DataTable  GetColumnDataNamesType(System.Data.DataTable table)         {             DataTable dt = new DataTable();             dt.Columns.Add("name", typeof(string));             dt.Columns.Add("datatype", typeof(string));               if (table != null)             {                               foreach (System.Data.DataColumn col in table.Columns)                 {                                           dt.Rows.Add(col.ColumnName, table.Columns[col.ColumnName].DataType.ToString());                 }                            }               return dt;           }