Serverversion exception. Invalid operation. The connection is closed. Solution

[Copyright Disclaimer: This article is the original topic of the tewei blog and is not reprinted without permission. If you need to repost the message, make sure to enter the address of this blog .]

Problem: State closed system. Data. connectionstate
The connection is not open ().
Add in try
If (oledbconnection1.state! = Connectionstate. open)
Oledbconnection1.open ();
Add
Finally
{
If (oledbconnection1.state! = Connectionstate. Close)
{
Oledbconnection1.close ();
}
}

 

See http://bbs.csdn.net/topics/90347542

 

 

1. /// <Summary>
2. /// Add an object
3. /// </Summary>
4. /// <Param name = "syscompany"> </param>
5. /// <Param name = "sysuser"> </param>
6. Public bool insertentities (tsyscompany syscompany, tsysuser sysuser)
7. {
8. Using (teacrmdbcontext DB = new teacrmdbcontext ())
9. {
10. If (db. Connection. State! = Connectionstate. open)
11. {
12. DB. Connection. open ();
13. }
14. VaR TRAN = dB. Connection. begintransaction ();
15. Try
16. {
17. DB. tsyscompanies. insert (syscompany );
18. DB. tsysusers. insert (sysuser );
19. Tran. Commit ();
20. Return true;
21. }
22. Catch (exception ex)
23. {
24. Tran. rollback ();
25. Throw new exception (ex. Message );
26. Return false;
28. }
29. Finally
30. {
31. If (db. Connection. State! = Connectionstate. Closed)
32. {
33. DB. Connection. Close ();
34. }
35. }
36. }
37. }