D.B disconnect after run application

Aktham Mahmoud

7y1.8k.NET

Good Times all

Actually, these problem is a first time faced me. I worked in web development for long time, but I don't know If someone faced a same problem befor,

Introduction:

I've a web app, and D.B connecte with site application, If i open a data base to add make (CRUD) operations on data tables or add/remove table, a Database opening before run application in (SQL server data base explore) in visual Studio 2012.

Problem description:

when I run app. and logging to site adminstration, if I select a to add data to data base, a message show(No D.B) connection).

You can see a capture screen to show details.

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aktham Mahmoud7y ago
HI Rajanikkant
Actually i'm tryed to sind soulution, but the one solution is :
Delete database from (SQL SERVER OBJECT Explorer).
Delete database from (SQL SERVER Explorer).
Attach Database again.
Rajanikant Hawaldar7y ago
OK, connection is closed so check in function open with conObj.Open()
Aktham Mahmoud7y ago
I Know all line, and Icone, to refresh it..
I I tolde you lastly, I refresh the connection, and a D.B opened.

But when I run App.. disconnect the connection..
Rajanikant Hawaldar7y ago
Is that you talking about the icon in the server explorer of the Visual Studio? Thats nothing to worry about it. It means that the database is now offline or detached. If you want to bring it online, just double click on it, or right click -> refresh and the icon automatically changes to small plug and is accessible. Mark answer as accepted if it is correct