Get all column names of a DataTable into string array using LINQ Predicate

Question

I know we can easily do this by a simple loop  but I want to persue this LINQ Predicate   string   columnNames   dt Columns    or  string   columnNames   from DataColumn dc in dt Columns select dc name

User · Answer

Use   var arrayNames    from DataColumn x in dt Columns                   select x ColumnName  ToArray

User · Answer

Try this  LINQ method syntax      string   columnNames   dt Columns Cast lt DataColumn gt                                      Select x   gt  x ColumnName                                    ToArray        or in LINQ Query syntax     string   columnNames    from dc in dt Columns Cast lt DataColumn gt                            select dc ColumnName  ToArray      Cast is required  because Columns is of type DataColumnCollection which is a IEnumerable  not IEnumerable lt DataColumn gt   The other parts should be obvious

User · Answer

I d suggest using such extension method   public static class DataColumnCollectionExtensions       public static IEnumerable lt DataColumn gt  AsEnumerable this DataColumnCollection source                return source Cast lt DataColumn gt               And therefore   string   columnNames   dataTable Columns AsEnumerable   Select column   gt  column Name  ToArray      You may also implement one more extension method for DataTable class to reduce code   public static class DataTableExtensions       public static IEnumerable lt DataColumn gt  GetColumns this DataTable source                return source Columns AsEnumerable              And use it as follows   string   columnNames   dataTable GetColumns   Select column   gt  column Name  ToArray

User · Answer

List lt String gt  lsColumns   new List lt string gt      if dt Rows Count gt 0        var count   dt Rows 0  Table Columns Count       for  int i   0  i  lt  count i                   lsColumns Add Convert ToString dt Rows 0  i

[c#] Get all column names of a DataTable into string array using (LINQ/Predicate)

Examples related to c#

Examples related to .net

Examples related to linq

Examples related to datatable