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

You can do without linq by dt.Rows[0]["columnName"].ToString(); — Indi
– Indi, Commented Mar 15, 2012 at 8:35
Yes, I just wanted to know how to do it with linq due to code maintance — David Rasuli
– David Rasuli, Commented Mar 15, 2012 at 8:37

Tim Schmelter · Accepted Answer · 2014-06-27 09:15:24Z

9

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

edited Jun 27, 2014 at 9:15

answered Mar 15, 2012 at 8:34

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

David Rasuli Over a year ago

Hi Tim, thanks for your comment. I don't fully understand the syntax here as I wished to perform this action on a specific row (lets say Rows[0]) how do I see it at your example?

Tim Schmelter Over a year ago

@DavidRasuli: If you only have one row and you only want to get a specific field value, use the first method i've shown(row.Field<int>("Item1")). Otherwise explain what you're trying to achieve.

Rawling · Accepted Answer · 2012-03-15 08:33:42Z

2

If you use the Item indexer rather than ItemArray, you can access items by column name, regardless of whether you use LINQ or not.

dt.Rows[0]["Column Name"]

answered Mar 15, 2012 at 8:33

Rawling

50.3k7 gold badges94 silver badges131 bronze badges

Comments

Dummy01 · Accepted Answer · 2012-03-15 08:41:20Z

1

Tim Schmelter's answer is probably what you are lookin for, just to add also this way using Convert class instead of DataRow.Field:

var q = (from row in dataTable.AsEnumerable() select Convert.ToInt16(row["COLUMN1"])).ToArray();

answered Mar 15, 2012 at 8:41

Dummy01

1,9951 gold badge16 silver badges21 bronze badges

Comments

erikT · Accepted Answer · 2020-08-13 00:06:38Z

Here's what I've come up with today solving a similar problem. In my case: (1)I needed to xtract the values from columns named Item1, Item2, ... of bool type.

(2) I needed to xtract the ordinal number of that ItemN that had a true value.

var itemValues = dataTable.Select().Select(
                r => r.ItemArray.Where((c, i) =>
                dataTable.Columns[i].ColumnName.StartsWith("Item") && c is bool)
                .Select((v, i) => new { Index = i + 1, Value = v.ToString().ToBoolean() }))
                                        .ToList();


  if (itemValues.Any())
  {
        //int[] of indices for true values
        var trueIndexArray = itemValues.First().Where(v => v.Value == true)
                    .Select(v => v.Index).ToArray();
  }

forgot an essential part: I have a .ToBoolean() helper extension method to parse object values:

    public static bool ToBoolean(this string s)
    {
        if (bool.TryParse(s, out bool result))
        {
            return result;
        }

        return false;
    }

Collectives™ on Stack Overflow

Getting a cell from DataTable.Row.ItemArray with Linq

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related