Can I retrieve a SqlDataReader from a SqlConnection object?

microsoft.public.dotnet.framework.adonet

2 Feb 2007 10:12 PM

Valerie Hough

Is it possible to retrieve an SqlDataReader object (if one exists) from the
SqlConnection object or the SqlCommand object with which it is associated?

Thanks in advance

3 Feb 2007 1:18 PM

William (Bill) Vaughn

Ah, sure. But it's not really an "object" like a DataTable that can be
carried around in memory. It's a portal to the results from a SqlCommand.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

Show quote

"Valerie Hough" <sa***@pcTrans.com> wrote in message
news:OVVfoaxRHHA.1000@TK2MSFTNGP05.phx.gbl...
> Is it possible to retrieve an SqlDataReader object (if one exists) from
> the SqlConnection object or the SqlCommand object with which it is
> associated?
>
> Thanks in advance
>
>