cjard
Well-known member
- Joined
- Apr 25, 2006
- Messages
- 7,081
- Programming Experience
- 10+
"The connection was not closed. The connection's current state is connecting"
I see this error crop up occasionally. The following thread makes reference to taking care when using connections in multithreaded environments:
http://www.pcreview.co.uk/forums/thread-2369340.php
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2125567&SiteID=1
My question is.. how am I to take care, when the DataSet generator writes the code that does all the connection handling?
Note; i just remembered, I have only one tableadapter that is shared between threads. I dont know if I should pool them, creating a new one whenever the current one is still in use..
I see this error crop up occasionally. The following thread makes reference to taking care when using connections in multithreaded environments:
http://www.pcreview.co.uk/forums/thread-2369340.php
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2125567&SiteID=1
My question is.. how am I to take care, when the DataSet generator writes the code that does all the connection handling?
Note; i just remembered, I have only one tableadapter that is shared between threads. I dont know if I should pool them, creating a new one whenever the current one is still in use..
Last edited: