-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Rajiv R
Message 2 in Discussion
Hi
Srini,
you are allowed only one
DataReader per Connection and it will block any other data access..... u need to
close one and then open another.... in your case u might hv to use 2 different
connections....
but do look into the "some code" if u can accomplish ur
functionality by using a single sql query (i always try to offload data
manipulation to queries and avoid them in code as much as possible.....), hence
a since sdr wud suffice....!
hope it helps!
Cheers!
Rajiv.
R
-----Original Message-----
From: BDOTNET
[mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003
11:41 AM
To: [EMAIL PROTECTED]
Subject: Data
Reader Problem
New Message on BDOTNET
Data
Reader Problem
Reply
Recommend
Message 1 in
Discussion
From: Srini Rao
hi,
I am facing problem with
datareader,the error i am getting is "There is already an open
DataReader associated with this Connection which must be closed
first."
in the code
While
(reader1.Read())
....Some
code
while(reader2.read())
....Some
code
end
while
reader2.close()
end
while
reader1.close()
i
am using two different SQLCommand objects and two different
readers.the same piece of code working fine dotnetframe work
1.0/VS.net ,now i have upgraded to dotnetframework 1.1/VS2003
and i changes the data source from Oracle to SQL Server
If
any body face similar kind of problem let me
know.
thanks
-Srini
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
