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...

Nic

There is a good reason for looping, see #8918657 – Arie

don't you think you will loop over all the records during conversion? – Granulose

Answer 1

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

Hereditable

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. – Nic

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. – Hereditable

@Nic I am getting the same error, even with this split up over multiple lines. Did you ever get it resolved? – Tarter

@Tarter yep, try something like this var foo = dt.AsEnumerable().Select(x => x.ItemArray).ToArray(); – Nic

Answer 2

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

Acreinch

Answer 3

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

Flourishing