DataReader to ArrayList

[A.M]

Hi,

What would be the fastest way to transfer a one column DataReader into a
ArrayList ?

Thanks,
Alan

 

[William Ryan eMVP]

while(rdr.Read()){
myArrayList.Items.Add[rdr.Getxxxx[0]);
}

 

[A.M]

Thanks for reply,
I was thinking that there are integration between intrfaces, so instead of
creating a loop, we can use methods doing that.

Is it the same with DataSet (only method to copy is creating a loop) ?

Alan

while(rdr.Read()){
myArrayList.Items.Add[rdr.Getxxxx[0]);
}

Hi,

What would be the fastest way to transfer a one column DataReader into a
ArrayList ?

Thanks,
Alan

 

[William Ryan eMVP]

Not in a reader... it only works when connected...

Thanks for reply,
I was thinking that there are integration between intrfaces, so instead of
creating a loop, we can use methods doing that.

Is it the same with DataSet (only method to copy is creating a loop) ?

Alan

while(rdr.Read()){
myArrayList.Items.Add[rdr.Getxxxx[0]);
}

Hi,

What would be the fastest way to transfer a one column DataReader into a
ArrayList ?

Thanks,
Alan

 

[William Ryan eMVP]

Sorry about that, I hit send by accident. Anyway, depending on how the
reader is structured you can use GetValues of the reader. Datasets/tables
are structured differently b/c you don't have to move forward through it. A
datatable you can access anyway you like. There's a method for instance,
GetItemArray of the datarow that can accomplish this for you

Thanks for reply,
I was thinking that there are integration between intrfaces, so instead of
creating a loop, we can use methods doing that.

Is it the same with DataSet (only method to copy is creating a loop) ?

Alan

while(rdr.Read()){
myArrayList.Items.Add[rdr.Getxxxx[0]);
}

Hi,

What would be the fastest way to transfer a one column DataReader into a
ArrayList ?

Thanks,
Alan