How to convert a column of DataTable to a List

Question

I have a DataTable with multiple columns  I want to get a List lt String gt  out of first column of DataTable  How can I do that

User · Answer

var list   dataTable Rows OfType lt DataRow gt         Select dr   gt  dr Field lt string gt  columnName   ToList       Edit   Add a reference to System Data DataSetExtensions to your project if this does not compile

User · Answer

Here you go              DataTable defaultDataTable   defaultDataSet Tables 0              var list    from x in defaultDataTable AsEnumerable                       where x Field lt string gt   column1      something                     select x Field lt string gt   column2    ToList      If you need the first column             var list    from x in defaultDataTable AsEnumerable                       where x Field lt string gt  1     something                     select x Field lt string gt  1   ToList

User · Answer

Try this   static void Main string   args        var dt   new DataTable               Columns        Lastname  typeof string        Firstname  typeof string                 dt Rows Add  Lennon    John        dt Rows Add  McCartney    Paul        dt Rows Add  Harrison    George        dt Rows Add  Starr    Ringo         List lt string gt  s   dt AsEnumerable   Select x   gt  x 0  ToString    ToList         foreach string e in s          Console WriteLine e        Console ReadLine

User · Answer

I do just like below  after you set your column AsEnumarable you can sort  order or how you want     dataTable AsEnumerable   Select p   gt  p Field lt string gt   ColumnName    ToList

User · Answer

1 Very Simple Code to iterate datatable and get columns in list   2 code             foreach  DataColumn dataColumn in dataTable Columns         var list   dataTable Rows OfType lt DataRow gt          Select dataRow   gt  dataRow Field lt string gt           dataColumn ToString     ToList

User · Answer

Is this what you need   DataTable myDataTable   new DataTable    List lt int gt  myList   new List lt int gt     foreach  DataRow row in myDataTable Rows        myList Add  int row 0

User · Answer

I make a sample for you   and I hope this is helpful         static void Main string   args                var cols   new string      col1    col2    col3    col4    col5              DataTable table   new DataTable            foreach  var col in cols              table Columns Add col            table Rows Add new object      1    2    3    4    5              table Rows Add new object      1    2    3    4    5              table Rows Add new object      1    2    3    4    5              table Rows Add new object      1    2    3    4    5              table Rows Add new object      1    2    3    4    5               foreach  var col in cols                        var results   from p in table AsEnumerable                             select p col                Console WriteLine                                           foreach  var result in results                                Console WriteLine result                                     Console ReadLine

[c#] How to convert a column of DataTable to a List

Examples related to c#

Examples related to .net

Examples related to list

Examples related to datatable