Csharp: datatable get Column datatype or Column Name, csharpdatatype

Csharp: datatable get Column datatype or Column Name, csharpdatatype

/// <Summary> /// list name /// </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 (); //} // <su Mmary> // data type // </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> /// column name and Data Type /// </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 ;}