ExecuteScalar function question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

awiesendanger - 14 Jun 2004 20:10 GMT

Does the ExecuteScalar function use a DataReader behind the scenes? I
had 2 objects that used the same IDbConnection object, and each
object called ExecuteScalar(neither called ExecuteReader). One
completed successfully, the other got the error that a DataReader was
already opened and must be closed first. So I guess ExecuteScalar
uses a Reader?

Reply to this Message

Marina - 14 Jun 2004 20:21 GMT

Yes, it does. The Fill method of the data adapter uses it behind the scenes
as well.

> Does the ExecuteScalar function use a DataReader behind the scenes? I
> had 2 objects that used the same IDbConnection object, and each
[quoted text clipped - 7 lines]
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...