Feed a DataSet directly into an array

[ckane55436]

I want to read a table of data direclty into a multi-dimensional array for processing purposes. How can this easily be done?

Or put it differently - How can I bind a datasource to an array?

 

[cjard]

Why bother? A dataset is already a 3 dimensional array:

DataSet.Tables(X).Rows(Y)(Z)

When considering the functionality and type strictness offered by DataSet/Table/Row, Arrays are practically retarded, by comparison


Why would you want to bind a datasource to an array? Arrays are prehistoric data containers with very few applications in modern programming

 

[ckane55436]

Arrays vs dataset

I assume I can add columns to the dataset on the fly to store calculated values.

 

[cjard]

Yep. You cannot add elements to an array so if youre after extensible collections, arrays are the LAST thing you should consider

 

[ckane55436]

arrays

What would you do if you needed temporary storage for a new "array" from a dataset.

For example, have a dataset, add some new columns for calucaltions and then want to do transformations on the "array"

 

[cjard]

Can you be more spcific? I dont quite understand your question..

Given that a datatable can be accessed in row, column fashion:

MyDataTable(row)(column)

Whatever you would do with an array, also accessed in this fashion, will be quite easy..
And remember that a DataSet is an "array" (collection) of DataTables..