How do you fill an array dynamically using a datareader
Posted on 2004-08-30
I have managed to dynamically dimension an array.
ReDim MyArray(nCountOfRecords) 'This dynamically sets the size of my array
What I want to do is pull 1 column of Integer values from 1 sql database table into my array and then be able to access any value in my array.
I would prefer to loop throught the datasource with a datareader if this is the fastest.
Suppose I want to access the following.
Thanks in advance