oledbDatareader.read

[mcerk]

hi. is there any faster way (like: MyReader = myVariable)?

 

           While MyReader.Read
               ReDim Preserve myVariable(i)
               myVariable(i) = MyReader("id")
               i = i + 1
           End While

[AFterlife]

I would use an arraylist or collection. Instead of using slow things like redim preserve.

[mcerk]

hm.... that is exacty what my question was. I don't know how to do it. Can you post sample code please?

[AFterlife]

         Dim myVariable As New ArrayList
         While MyReader.Read
                myVariable.Add(MyReader("id"))
           End While 

[mcerk]

I know, that this questions are newbie like, but how can I then cycle through ArrayList?

if it would be ordinary array, I woudl do

 

For i = 0 to Ubound(myVariable)
   Messagebox.show(myVariable(i))
Next i

 

 

How can I do this with arraylist?

 

tx, matej

[AFterlife]

I know, that this questions are newbie like, but how can I then cycle through ArrayList?

if it would be ordinary array, I woudl do

 

For i = 0 to Ubound(myVariable)
   Messagebox.show(myVariable(i))
Next i

 

 

How can I do this with arraylist?

 

tx, matej

Same exact way.