Datatable conversion to an array

[Rui Sampainho]

Hi

Is there any command to transfer the contents of a datatable to an array.
What I'm looking for is sort of a bulk process, not an iteration with a loop
based on a field by field or row by row process.

Regards
RMS

[Fergus Cooney]

Hi Rui,

What would you like your array to contain? Are you after a multi-dimensional array of Objects? Or a single-dimensional
array of Somethings?

This is what the DataTable would be asking if it could. Given that it can't anticipate or ask, it offers a collection
of Rows.

What did you have in mind?

Regards,
Fergus

[Armin Zingler]

"Rui Sampainho" <rs********@hotmail.com> schrieb

Is there any command to transfer the contents of a datatable to an
array. What I'm looking for is sort of a bulk process, not an
iteration with a loop based on a field by field or row by row
process.

Untested:
A DataTable implements the interface ICollection. The interface has a CopyTo
method.
--
Armin

http://learn.to/quote
http://www.plig.net/nnq/nquote.html

[Armin Zingler]

"Armin Zingler" <az*******@freenet.de> schrieb

Untested:
A DataTable implements the interface ICollection. The interface has a
CopyTo method.

Correction:
DataTable.Rows returns a System.Data.DataRowCollection that implements
ICollection.

Sorry.
--
Armin

http://learn.to/quote
http://www.plig.net/nnq/nquote.html

[Herfried K. Wagner [MVP]]

* "Rui Sampainho" <rs********@hotmail.com> scripsit:

Is there any command to transfer the contents of a datatable to an array.

Which part of the datatable do you want to store in an array?

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>

[Rui Sampainho]

Hi Fergus!

I need to export the contents of a table to an Excel Spreadsheet. This table
has about 3000 rows.
I already have a very fast one-step process for transfering all of an array
content to excel (therefore the array has 2 dimensions - one for rows and
another for columns, so what I believe I need is a multi-dimensional array
of somethings - like strings).

The alternative I have in hands is to either loop through the items (or
maybe rows) of the datatable exporting them one-by-one, or looping through
the contents of the datatable and assigning the values to the array.
Whichever case makes the process a bit too slow and inefficient.

For example, the .lines property of a multi-lined string automatically
creates a 1 dimension array with all the lines of the string.

I guess what I'm looking for a similar process applied to the datatable case
(with lines and columns)

Thanks again

What I have in mind is transfering the actual datatable contents to an excel
spreadsheet.

"Fergus Cooney" <fi****@post.com> escreveu na mensagem
news:OM**************@TK2MSFTNGP10.phx.gbl...

Hi Rui,

What would you like your array to contain? Are you after a multi-dimensional array of Objects? Or a single-dimensional array of Somethings?

This is what the DataTable would be asking if it could. Given that it can't anticipate or ask, it offers a collection of Rows.

What did you have in mind?

Regards,
Fergus

[Rui Sampainho]

the field values themselves

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> escreveu na mensagem
news:bo*************@ID-208219.news.uni-berlin.de...

* "Rui Sampainho" <rs********@hotmail.com> scripsit:

Is there any command to transfer the contents of a datatable to an

array.
Which part of the datatable do you want to store in an array?

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>

[Herfried K. Wagner [MVP]]

* "Rui Sampainho" <rs********@hotmail.com> scripsit:

the field values themselves

Have a look at Armin's suggestion...

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>

[Fergus Cooney]

Hi Rui,

There's no way that the Table itself can do the job, for the reason hinted at before.

However, the Table does have the Rows Collection and each Row can provide an ItemArray which is an array of Objects. At
least this will save you having to address each item by name. Unfortunately you will still need to turn each Object into a
string, whether in your 2D array or deferred until the export. Can your export routine handle an array of arrays?

I think the Rows -> array -> Excel would be faster than exporting each Row separately, but you'd know better - you have
the fast array-export. Looking in my crystal ball I see some experimentation and timing tests in your future.

Sorry I can't be more definite. Good luck!

Regards,
Fergus

[Cor]

Hi Rui,

Why not bring the table to a dataset and then with dataset.writexml("file")
you have your xml file that you can read in your Excel spreadsheet.

I thought it was something untested
\\\\
ds as new dataset
ds.tables.add(yourtable)
ds.writexml("yourfile")
////

Cor