Return an array from Data Reader?

[Ecreations]

Hi Guys,
Is there any ways a Data Reader returns an array?
I managed to to get all values returned from the Data Reader into a an arraylist.
here is the code
Do while ObjReader.Read()
For IntCounter = 1 to ObjReader.Fieldcount - 1
MyArray.add(CSTR(ObjReader.GetValue(IntCounter))
Next Intcounter
loop

 

[link9]

ArrayList contains a .ToArray() method that would work nicely for this.

-paul

The answer to getting answered -- faq855-2992

 

[Ecreations]

hey thanks Paul
i figured that out the hard way.
heres the code i used
Dim NewsArray as New ArrayList
Dim Obj as Object
Dim i As Int32 = 0

Dim StrArray(NewsArray.Count) As String
For Each obj In NewsArray
StrArray(i) = obj.ToString
i += 1
Next obj
the StrArray will contain all the Object data as a string array



The solution is simple, the problem is complex.

http://www.ecreationscanada.com