data reader and connection error

[rajrprk]

this is the following error i have There is already an open DataReader associated with this Command 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.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.

[Karthik A]

Google is your friend. Anyways check this out - http://blogs.msdn.com/b/spike/archive/2009/08/20/there-is-already-an-open-datareader-associated-with-this-command-which-must-be-closed-first-explained.aspx[^]. I guess you are using a SqlDataReader. Before you attempt to use it again for a new query close the old one. Refer to the link above.

Cheers, Karthik

[Luc Pattyn]

Don't create a mess, there is no need to start three different threads about a single problem. Please stick to the original thread, and either edit your existing post or add new messages in that thread. :|

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

[Pete OHanlon]

If you want to open multiple data readers on a single connection, and you have SQL Server 2005 or later running, you need to enable MARS (Multiple Active Result Sets). To enable it, add

MultipleActiveResultSets=True

to the end of the connection string.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx