LINQ: Get all the values from a column in a DataTable in C#

Kabwla.Phone

Rate me:

1.00/5 (1 vote)

18 Oct 2011CPOL

22.4K

Which will crash if the datatype of the column is not a string.You might also want to note that this only works for typed datasets.This version works for all datasets, can handle any datatype, and handles null values: table.Rows.AsQueryable() // make...

Which will crash if the datatype of the column is not a string.
You might also want to note that this only works for typed datasets.

This version works for all datasets, can handle any datatype, and handles null values:

table.Rows.AsQueryable<datarow>()                   // make enumerable
.Select(row => (row["fieldname"] ?? "").ToString()) // get value
.ToArray();                                         // as array

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Kabwla.Phone

Software Developer (Senior)

Netherlands

Doing that 'computer thing' ever since the C64.

Sometimes I feel that being a programmer is much like being a doctor: You just have to know everything and if you don't, something dies.

Either being an application or a patient.

Oddly enough, more people care about the death of their application, than the massacre of people...

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

LINQ: Get all the values from a column in a DataTable in C#

License

Comments and Discussions