Although you could write a custom function to mimic ReDim, the easiest
way is to use an ArrayList instead of normal array. It is in
System.Collections namespace.
Hi,
As Hong Thi suggested you better use an ArrayList for this , this is in the
case you need to keep ALL the values you read, if all you need is the
maximun then you better keep it in a temp variable and no use a collection
at all :
int maxValue= Int32.MinValue;
while( db.read() )
if ( Convert.ToInt32( db["TestID"]) > maxValue )
maxValue = Convert.ToInt32( db["TestID"]) ;
cheers,

Signature
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
> Hi
>
[quoted text clipped - 41 lines]
> thanks
> Jyothi