Datatable to Multidimensional Array

Question

Is there an easy way to convert a Datatable to a multidimensional string array?

Maybe using LINQ?

There's gotta be a better way than manually looping through all the columns/rows...

There is a good reason for looping, see http://stackoverflow.com/questions/8918157/how-do-i-convert-a-resultset-in-a-list-of-hashtable/8918431#8918431 — Miserable Variable, Jan 19 '12 at 20:39
don't you think you will loop over all the records during conversion? — rerun, Jan 19 '12 at 20:42

Gabriel GM · Accepted Answer · 2012-01-26T14:04:56.047

8

Linq is the answer. You can convert a DataTable to IEnumerable using the AsEnumerable method. Then, the ToArray() converts it to an array.

var tableEnumerable = DataTableName.AsEnumerable();
tableArray = tableEnumerable.ToArray();

edited Jan 26 '12 at 14:04

answered Jan 19 '12 at 20:43

Gabriel GM

2

sorry, I've never used LINQ before. I'm getting this error `Cannot implicitly convert type 'System.Data.DataRow[]' to 'string[*,*]'` Any help would be greatly appreciated. – Greg Jan 19 '12 at 21:46
are you getting that error on the line I gave you? If so, can you break it into different parts (enumerable = DataTable.asenumerable(); tablearray = enumerable.toarray();) and see if it still react the same. – Gabriel GM Jan 20 '12 at 12:35
@Greg I am getting the same error, even with this split up over multiple lines. Did you ever get it resolved? – Rachel Apr 03 '13 at 19:52
1

@Rachel yep, try something like this `var foo = dt.AsEnumerable().Select(x => x.ItemArray).ToArray();` – Greg Apr 03 '13 at 21:03

score 4 · Answer 2 · answered Oct 30 '13 at 10:29

4

yourTable.AsEnumerable().Select(row => row.ItemArray).ToArray()

answered Oct 30 '13 at 10:29

user2782518

score 0 · Answer 3 · answered Jan 20 '12 at 06:17

0

try dt.Rows.Cast().Select(//datarow to strings)

answered Jan 20 '12 at 06:17

Gavin Fang

3 Answers3