Re: [DOTNET] Quickly copy data out of SQLDataReader

[Jim Arnold]

You'll need to enumerate it in some way - there's no ReadToEnd() or
equivalent.  The easiest is probably:


ArrayList columns = new ArrayList();

while(rdr.Read()) {
        object[] row = new object[rdr.FieldCount];
        rdr.GetValues(row);
        columns.Add(row);
}

Jim

> -----Original Message-----
> From: Curtis Koppang [mailto:[EMAIL PROTECTED]]
> Sent: 29 May 2002 12:34
> To: [EMAIL PROTECTED]
> Subject: [DOTNET] Quickly copy data out of SQLDataReader
>
>
> Is there a way to quickly copy the data out of SQLDataReader
> like into a Stream or an Array?  I seem to recall something
> like this on the Recordset which copied all the data into a VT.
>
> Thanks,
> curt
>
> You can read messages from the DOTNET archive, unsubscribe
> from DOTNET, or
> subscribe to other DevelopMentor lists at http://discuss.develop.com.
>

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.