[Dnfbb-developers] [ dnfbb-Bugs-1420433 ] Datareader problem

[SourceForge.net <no...@so...>]

Bugs item #1420433, was opened at 2006-01-31 12:28
Message generated for change (Settings changed) made by sbosanquet
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=784889&aid=1420433&group_id=152364

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 5
Submitted By: Bosie (sbosanquet)
>Assigned to: Bosie (sbosanquet)
Summary: Datareader problem

Initial Comment:
Error: "There is already an open DataReader 
associated with this Connection which must be closed 
first"

Attached are some test files which can be used to try 
and diagnose the problem.

One area where i have had this problem has been when 
the input type to the stored procedure is incorrect 
but becasue of the way the catch statements are 
structured you miss it and get an open datareader 
when you try and issue a rollback command.  This 
overwirtes the exception.

I run this example through a new project.  The .cs 
file contains a function which does all of the 
database reading etc.  Execute the function and you 
should see the output.

One thing not to forget is to add a reference to the 
MySQL dll if you are using a new project.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=784889&aid=1420433&group_id=152364