Convert a DataTable to multidimensional array C#

Question

I'm trying to convert a DataTable's rows into multidimensional array:

DataTable DT = new DataTable();
DT.Columns.AddRange
(
   new DataColumn[]
   { 
           new DataColumn("LA_ID"), 
           new DataColumn("contractid") 
   }
);

for(int i=1000; i<=1100; i++)
   DT.Rows.Add(i, i);

EnumerableRowCollection<DataRow> appsEnum = DT.AsEnumerable();

int[,] apps = appsEnum.
               Where(x => x.Field<int>("LA_ID") > 1050).
               Select(x => x.Field<int>("LA_ID"), x.Field<int>("contractid")).
--Error Here-------------------------------------^
               ToArray();

Can anyone help plz.

enter image description here

Does it throw an exception? Post the exception. Does the LA_ID property exist? — Jite
– Jite, Commented Mar 14, 2015 at 8:02

Henk Holterman · Accepted Answer · 2015-03-14 08:15:55Z

2

There is no version of .ToArray() that supports more than 1 dimension. You will need a for-loop here.

It could probably work with a int[][] but not for int[,]

answered Mar 14, 2015 at 8:15

Henk Holterman

276k33 gold badges353 silver badges540 bronze badges

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

1 Comment

amiry jd Over a year ago

It absolutely works with a int[][] but not for int[,]

ASh · Accepted Answer · 2015-03-14 08:18:10Z

1

the best you can get with ToArray() method is jagged array

int [][] apps = appsEnum.
           Where(x => x.Field<int>("laid") > 1050).
           Select(x => new int[] {x.Field<int>("LA_ID"), x.Field<int>("contractid")}).
           ToArray();

consider another approach

DataRow[] rows = DT.Select("laid > 1050");

int[,] apps = new int[rows.Length, 2];

for(int r=0; r<rows.Length; r++)
{
   apps[r,0] = rows[r].Field<int>("LA_ID");
   apps[r,1] = rows[r].Field<int>("contractid");
}

answered Mar 14, 2015 at 8:18

ASh

35.9k9 gold badges68 silver badges89 bronze badges

Collectives™ on Stack Overflow

Convert a DataTable to multidimensional array C#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related