converting a DataTable to an array using select

Question

I am trying to convert a DataTable to array using Select and toArray I did this:

List<int> LevelsArray = CardServiceDetailsDt.Select("LEVEL_ID").ToList<int>();

but an error is accrued

'System.Data.DataRow[]' does not contain a definition for 'ToArray' and the best extension method overload 'System.Linq.Enumerable.ToArray<TSource>(System.Collections.Generic.IEnumerable<TSource>)' has some invalid arguments

King King · Accepted Answer · 2013-12-03 11:37:29Z

1

Select will filter the rows for you but looks like you want to get all the values in one column, so you can't use Select, try this instead:

var rows = CardServiceDetailsDt.AsEnumerable()
                 .Select(row=>row.Field<long>("LEVEL_ID")).ToArray();

edited Dec 3, 2013 at 11:37

answered Dec 3, 2013 at 11:10

King King

63.5k16 gold badges118 silver badges140 bronze badges

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

4 Comments

Sora Over a year ago

it gives me a the specific cast is not valid

King King Over a year ago

@Sora what's the actual type of LEVEL_ID?

Sora Over a year ago

it's ok i figure out that the actual type of LEVEL_ID is long

Matstar Over a year ago

Make sure you have imported: using System.Data;

Adil · Accepted Answer · 2013-12-03 11:09:39Z

0

You can use AsEnumerable() to call ToArray() also use Field to ge the column value of datatable.

ObjDt.AsEnumerable().Select
            (r => r.Field<string>("LEVEL_ID")).ToArray();

answered Dec 3, 2013 at 11:09

Adil

148k25 gold badges217 silver badges207 bronze badges

Comments

Christos · Accepted Answer · 2013-12-03 11:10:32Z

0

var array = CardServiceDetailsDt.Rows[i]
                                .ItemArray
                                .Select(x => x.ToString())
                                .ToArray();

i is the index of the row.

answered Dec 3, 2013 at 11:10

Christos

54.1k9 gold badges82 silver badges114 bronze badges

Collectives™ on Stack Overflow

converting a DataTable to an array using select

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related