Getting a cell from DataTable.Row.ItemArray with Linq

Question

I have the following ItemArray:

dt.Rows[0].ItemArray.. //{0,1,2,3,4,5}

the headers are : item0,item1,item2 etc..

So far, to get a value from the ItemArray I used to call it by an index.

Is there any way to get the value within the ItemArray with a Linq expression based on the column name?

Thanks

Answer 1

You can also use the column-name to get the field value:

int item1 = row.Field<int>("Item1");

• DataRow.Item Property(String)
• DataRow.Field Method: Provides strongly-typed access

You could also use LINQ-to-DataSet:

int[] allItems = (from row in dt.AsEnumerable()
                  select row.Field<int>("Item1")).ToArray();

or in method syntax:

int[] allItems = dt.AsEnumerable().Select(r => r.Field<int>("Item1")).ToArray();