Open Database File in Visual Studio

database not opening in visual studio
I could not open database files that were crated in Visual Studio 2008 after I created roles in the application. The App_Data file does not expand as it should bee. There is no other option in menu available to review the data.

The solution is, go to “Server Explorer” TAB. If not not already seen, enable it from view menu. Click the Add database icon. The following dialog will popup. Select “the database file option”
connect data file

In Solution explorer, right click on the App_Data folder and select open in Explorer. Copy the path and past it the previous step after you press ok and then browse button.

This should connect your local files in Visual Studio. Right click on the table and select “show table data”

Show Table Data

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s