How to convert a DataTable column to a list

Question

I have a DataTable with multiple columns. I want to get a List<String> from the first column of a DataTable. How can i do this?

Answer 1

Try the following:

 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<string> s = dt.AsEnumerable().Select(x => x[0].ToString()).ToList(); foreach(string e in s) Console.WriteLine(e); Console.ReadLine(); } 

Answer 2

 var list = dataTable.Rows.OfType<DataRow>() .Select(dr => dr.Field<string>(columnName)).ToList(); 

[ Edit : add a link to System.Data.DataSetExtensions to the project if this is not compiled]

Answer 3

Here you go.

  DataTable defaultDataTable = defaultDataSet.Tables[0]; var list = (from x in defaultDataTable.AsEnumerable() where x.Field<string>("column1") == something select x.Field<string>("column2")).ToList(); 

If you need the first column

  var list = (from x in defaultDataTable.AsEnumerable() where x.Field<string>(1) == something select x.Field<string>(1)).ToList(); 

Answer 4

This is what you need?

 DataTable myDataTable = new DataTable(); List<int> myList = new List<int>(); foreach (DataRow row in myDataTable.Rows) { myList.Add((int)row[0]); } 

Answer 5

I am making a selection for you, and I hope it will be useful ...

  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(); }