DataTable to Array of arrays

Question

I have a DataTable which consists of dynamic rows:

no   |   cid   | wait  |  prio
--------------------------------
1    |   1234  |  0:57 |    0
2    |   54785 |  0:44 |    0
3    |   74125 |  0:22 |    0

I want to create an array of arrays from this, having information of each row in an individual array.

The implementation of a DataTable is an array of arrays. The Rows property is the outer array and then each row has an ItemArray which is an object[] of values for that row. — Mike Perrenoud
– Mike Perrenoud, Commented Jun 5, 2013 at 14:21
@MichaelPerrenoud It doesn't matter once it's in a data table where the data came from... — Servy
– Servy, Commented Jun 5, 2013 at 14:27
Your data table already has everything you want, creating separate arrays is just adding pain to your process. I would suggest researching "accessing data from DataTables". — Evan L
– Evan L, Commented Jun 5, 2013 at 14:29

I4V · Accepted Answer · 2013-06-05 14:33:03Z

8

Although you don't need this

var arr = dataTable.Rows.Cast<DataRow>().Select(r => r.ItemArray).ToArray();

answered Jun 5, 2013 at 14:33

I4V

35.4k6 gold badges71 silver badges82 bronze badges

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

Comments

Evan L · Accepted Answer · 2013-06-05 14:37:25Z

3

Although I applaud other users for answering your direct question regarding an array of array. I think you are making this more difficult than you need to.

    yourDataTable.Rows[rowIndex]["no"]

is already an array containing all the values in your "no" column.

    yourDataTable.Rows[rowIndex]["cid"]

is already an array containing all the values in your "cid" column.

etc... etc..

You can access the data by either looping through the rows, or calling one directly in place of rowIndex as shown above, and assigning the value in the column to some other variable.

If you really want to get arrays of arrays (which you already have), then disregard this and refer to the other answers.

answered Jun 5, 2013 at 14:37

Evan L

3,8651 gold badge25 silver badges32 bronze badges

4 Comments

Mike Perrenoud Over a year ago

Though I'm only assuming here, the OP is likely sending this data to another assembly (i.e. unmanaged C or something like that) and it only supports an array.

Evan L Over a year ago

I considered that, but also felt that perhaps he does not know how to access the data directly, so thought it was worth a mention.

Servy Over a year ago

@MichaelPerrenoud While that's a possibility, that doesn't appear to be the case here

Evan L Over a year ago

Hey now, don't start arguing in comments on my answer please ;)

Francis.Beauchamp · Accepted Answer · 2013-06-05 14:25:03Z

1

Something like this would probably work as intended:

List<object> list = new List<object>();
foreach (object row in DataGridView.Rows)
    {
    List<object> newList = new List<object>();
    list.Add(newList);
    foreach (object columns in row)
    {
        newList.Add(columns.DataBoundItem);
    }
    }

answered Jun 5, 2013 at 14:25

Francis.Beauchamp

1,3731 gold badge15 silver badges28 bronze badges

Comments

Aemz · Accepted Answer · 2013-06-07 09:25:01Z

-4

There is no need to create array for data tables.

answered Jun 7, 2013 at 9:25

Aemz

1371 gold badge2 silver badges9 bronze badges

Collectives™ on Stack Overflow

DataTable to Array of arrays

4 Answers 4

Comments

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related