DataReader associated with this Connection

[Maziar Aflatoun]

Hi everyone,

I am working on the 'Delete' section of my program. What I need to do is
query my database and for every ID that it finds I want to remove a
file+ID.jpg from my file folder and update another table with that
information. However, I'm getting the following error message.

There is already an open DataReader associated with this Connection which
must be closed first.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidO perationExcepti on: There is already an
open DataReader associated with this Connection which must be closed first.

Source Error:
Line 471: SqlParameter BParBID = Cmd.Parameters. Add("@BID",
SqlDbType.Int);
Line 472: BParBID.Value = BID;
Line 473: Cmd.ExecuteNonQ uery();
Line 474:
Line 475: DeleteSQL = "DELETE FROM BannerInfo WHERE BID=@BID";

But this doesn't use the DataReader? only my query to find IDs is using the
datareader. Any idea why this is happening? and what would be a work-around
this?

Thank you
Maz.

[Marina]

Yes - the message says, there is already an open data reader on the
connection. Meaning, that because there is an open data reader, you cannot
do anything else with the connection until that datareader is closed.

So close your data reader before executing any queries, or create a second
connection.

"Maziar Aflatoun" <ma***@rogers.c om> wrote in message
news:xM******** **********@twis ter01.bloor.is. net.cable.roger s.com...

Hi everyone,

I am working on the 'Delete' section of my program. What I need to do is
query my database and for every ID that it finds I want to remove a
file+ID.jpg from my file folder and update another table with that
information. However, I'm getting the following error message.

There is already an open DataReader associated with this Connection which
must be closed first.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidO perationExcepti on: There is already an
open DataReader associated with this Connection which must be closed first.
Source Error:
Line 471: SqlParameter BParBID = Cmd.Parameters. Add("@BID",
SqlDbType.Int);
Line 472: BParBID.Value = BID;
Line 473: Cmd.ExecuteNonQ uery();
Line 474:
Line 475: DeleteSQL = "DELETE FROM BannerInfo WHERE BID=@BID";

But this doesn't use the DataReader? only my query to find IDs is using the datareader. Any idea why this is happening? and what would be a work-around this?

Thank you
Maz.

[Maziar Aflatoun]

I'm under the impression that it's a bad programming practise when you
create multiple connections. Is it?

Thanks
Maz.

"Marina" <so*****@nospam .com> wrote in message
news:e6******** *****@TK2MSFTNG P11.phx.gbl...

Yes - the message says, there is already an open data reader on the
connection. Meaning, that because there is an open data reader, you cannot
do anything else with the connection until that datareader is closed.

So close your data reader before executing any queries, or create a second
connection.

"Maziar Aflatoun" <ma***@rogers.c om> wrote in message
news:xM******** **********@twis ter01.bloor.is. net.cable.roger s.com...

Hi everyone,

I am working on the 'Delete' section of my program. What I need to do is
query my database and for every ID that it finds I want to remove a
file+ID.jpg from my file folder and update another table with that
information. However, I'm getting the following error message.

There is already an open DataReader associated with this Connection which
must be closed first.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidO perationExcepti on: There is already an
open DataReader associated with this Connection which must be closed

first.

Source Error:
Line 471: SqlParameter BParBID = Cmd.Parameters. Add("@BID",
SqlDbType.Int);
Line 472: BParBID.Value = BID;
Line 473: Cmd.ExecuteNonQ uery();
Line 474:
Line 475: DeleteSQL = "DELETE FROM BannerInfo WHERE BID=@BID";

But this doesn't use the DataReader? only my query to find IDs is using

the

datareader. Any idea why this is happening? and what would be a

work-around

this?

Thank you
Maz.

[Marina]

That depends. If you can get around by using 1, then creating extra ones is
bad - since you are wasting resources for no reason. But if you actually
need 2, then you need 2.

"Maziar Aflatoun" <ma***@rogers.c om> wrote in message
news:xU******** ********@news04 .bloor.is.net.c able.rogers.com ...

I'm under the impression that it's a bad programming practise when you
create multiple connections. Is it?

Thanks
Maz.

"Marina" <so*****@nospam .com> wrote in message
news:e6******** *****@TK2MSFTNG P11.phx.gbl...

Yes - the message says, there is already an open data reader on the
connection. Meaning, that because there is an open data reader, you cannot do anything else with the connection until that datareader is closed.

So close your data reader before executing any queries, or create a second connection.

"Maziar Aflatoun" <ma***@rogers.c om> wrote in message
news:xM******** **********@twis ter01.bloor.is. net.cable.roger s.com...

Hi everyone,

I am working on the 'Delete' section of my program. What I need to do is query my database and for every ID that it finds I want to remove a
file+ID.jpg from my file folder and update another table with that
information. However, I'm getting the following error message.

There is already an open DataReader associated with this Connection which must be closed first.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidO perationExcepti on: There is already an open DataReader associated with this Connection which must be closed

first.

Source Error:
Line 471: SqlParameter BParBID = Cmd.Parameters. Add("@BID",
SqlDbType.Int);
Line 472: BParBID.Value = BID;
Line 473: Cmd.ExecuteNonQ uery();
Line 474:
Line 475: DeleteSQL = "DELETE FROM BannerInfo WHERE BID=@BID";

But this doesn't use the DataReader? only my query to find IDs is using

the

datareader. Any idea why this is happening? and what would be a

work-around

this?

Thank you
Maz.

[Steve C. Orr [MVP, MCSD]]

It's a good idea to avoid multiple database connections when you can, but it
may be justified in this case.
Another possible solution is to load your data into a DataSet instead of a
DataReader. Since DataSets are disconnected you won't have this problem.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Maziar Aflatoun" <ma***@rogers.c om> wrote in message
news:xU******** ********@news04 .bloor.is.net.c able.rogers.com ...

I'm under the impression that it's a bad programming practise when you
create multiple connections. Is it?

Thanks
Maz.

"Marina" <so*****@nospam .com> wrote in message
news:e6******** *****@TK2MSFTNG P11.phx.gbl...

Yes - the message says, there is already an open data reader on the
connection. Meaning, that because there is an open data reader, you
cannot
do anything else with the connection until that datareader is closed.

So close your data reader before executing any queries, or create a
second
connection.

"Maziar Aflatoun" <ma***@rogers.c om> wrote in message
news:xM******** **********@twis ter01.bloor.is. net.cable.roger s.com...

Hi everyone,

I am working on the 'Delete' section of my program. What I need to do
is
query my database and for every ID that it finds I want to remove a
file+ID.jpg from my file folder and update another table with that
information. However, I'm getting the following error message.

There is already an open DataReader associated with this Connection
which
must be closed first.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidO perationExcepti on: There is already an
open DataReader associated with this Connection which must be closed

first.

Source Error:
Line 471: SqlParameter BParBID = Cmd.Parameters. Add("@BID",
SqlDbType.Int);
Line 472: BParBID.Value = BID;
Line 473: Cmd.ExecuteNonQ uery();
Line 474:
Line 475: DeleteSQL = "DELETE FROM BannerInfo WHERE BID=@BID";

But this doesn't use the DataReader? only my query to find IDs is using

the

datareader. Any idea why this is happening? and what would be a

work-around

this?

Thank you
Maz.