LINQ: Get all the values from a column in a DataTable in C#
LINQ: Get all the values from a column in a DataTable in C#
You can get the values from a named column in the
DataTable using a single line of code in LINQ.
Steps:
- Convert the
DataTableobject toEnumerable(). - Apply the
selectclause with the column name as field name. - Cast it to a
stringarray.string[] strSummCities = dtTemp1.AsEnumerable().Select(s => s.Field<string>("City")).ToArray<string>();