Can I retrieve a SqlDataReader from a SqlConnection object?

  • Thread starter Thread starter Valerie Hough
  • Start date Start date
V

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
 
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)
 
Back
Top