Help with Microsoft.ApplicationBlocks.Data Error Please

[Guest]

Hi
I have encountered an exception within SQLHelper.cs that i cannot fix.

The error message tells me that when running the ExecuteReader function
for about the 8th time in my program, that "An unhandled exception of type
'System.Data.SqlClient.SqlException' occured in
microsoft.applicationblocks.data.dll

Additional Information: System Error"

Does anyone know what is causing this problem, and more importantly, how to
fix it.

Any help would be greatly appreciated, as i feel i am banging my head
against a brick wall

Thanks

Rob

 

[Guest]

If it were me, I would run in debug until it errored out, as the source is
included with the block. Then, you have a decent idea what is happening. I am
not overly fond of the Reader implementation in the block, so I generally
stick with DataSets when using the block.


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

 

[Guest]

I've figured it out. I wasn't closing my DataReaders, and i had a loop which
opened a new one on each iteration. Closing them at the end of the iteration
fixed it.

Thanks for the reply though!

Rob