where do the built in database present in the visual studio 2010/2013

Question

0.00/5 (No votes)

See more:

hello everyone, i was working in built in database and accessing the register page in asp.net . so can i know where do i find the database so that i can see who are all the users registered and logged in .

Posted 23-Feb-14 18:29pm

kishorebt

Add a Solution

2 solutions

Solution 2

Hi,

VS 2013 comes in-built with SQL Express. This link[^] should help you get started with it and will also answer where the file can be found.

If you just want to locate the mdf file then the default location is:
C:\Users\<yourusername>\Documents\<thenameyouhadchosen>.mdf

Hope this helps.

[Please accept/up-vote answers or solutions that work for you to encourage participation]

Posted 23-Feb-14 18:39pm

CoderPanda

Updated 23-Feb-14 18:51pm

v3

Comments

kishorebt 24-Feb-14 0:43am

what ever the link uve given is to creation of database. im not looking for that, for example i am working on built in register page ,so i wanted to know who are all the users registered from backend (database).

CoderPanda 24-Feb-14 0:47am

What does your data connection show (in Server explorer)? Are you using the local DB? Are you connecting to an external DB instead?

kishorebt 24-Feb-14 0:52am

try out selecing a new web project and run that code. ull find a login and register page. so i want to access the database of it

CoderPanda 24-Feb-14 0:56am

Have you tried the ideas given by me and Snesh yet?

kishorebt 24-Feb-14 1:02am

ya tried out but no result :(

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Snesh Prajapati · Accepted Answer · 2014-02-23T18:38:00

Solution 1

It must be inside App_Data folder in your application. It may be as hidden file so first use "Show All Files" button in Solution explorer and then look inside App_Data folder.

One more thing....if you just created the ASP.NET application, by default database is not there. The Database will be created only when first time any user would register himself.

Even if not getting DB, then look into Web.Config....for myself I can see like:

add name="DefaultConnection" providername="System.Data.SqlClient" connectionstring="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-WebApplication1-20140223194834;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-WebApplication1-20140223194834.mdf"

The important value is: AttachDBFilename=|DataDirectory|\aspnet-WebApplication1-20140223194834.mdf".....Look into yours.

Posted 23-Feb-14 18:38pm

Snesh Prajapati

Updated 23-Feb-14 19:15pm

v4

Comments

kishorebt 24-Feb-14 0:43am

no content in appdata

Snesh Prajapati 24-Feb-14 0:45am

It may be as hidden file so first use "Show All Files" button in Solution explorer and then look inside App_Data folder.

Snesh Prajapati 24-Feb-14 0:47am

I can send you screenshot if you are facing problem in getting the option. in that case just share your email.

kishorebt 24-Feb-14 0:49am

kishorebt11@gmail.com

Snesh Prajapati 24-Feb-14 0:55am

Sent a mail to you...Hope the screenshot will solve problem. If still issue persist look into http://stackoverflow.com/questions/14383234/visual-studio-2012-show-all-files-button-missing

One more thing....if you just created the ASP.NET application, by default database is not there. The Database will be created only when first time any user would registered.

kishorebt 24-Feb-14 1:01am

ya ive 3 users created but there are no files in the app_data

Snesh Prajapati 24-Feb-14 1:04am

Then look into Web.Config....for myself I can see like:

add name="DefaultConnection" providername="System.Data.SqlClient" connectionstring="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-WebApplication1-20140223194834;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-WebApplication1-20140223194834.mdf"

What about you?

The important value is: AttachDBFilename=|DataDirectory|\aspnet-WebApplication1-20140223194834.mdf".....Let me know yours?

Snesh Prajapati 24-Feb-14 1:19am

Any update ?

kishorebt 24-Feb-14 2:16am

thnks a lot.. its been solved :)

Snesh Prajapati 24-Feb-14 3:30am

Most welcome.