Can I retrieve a SqlDataReader from a SqlConnection object?

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
 
W

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Three objects for handling databases in C# 0
Detect If SqlConnection Is In Use? 6
Looking for Comments on Code 5
Could you... 2
Invalid attempt to FieldCount when reader is closed 1
Temp table not visible in same SqlConnection 2
DAL technique - which is better 4
close SqlDataReader 1

Top