How to add existing database in app_data folder in asp.net

Question

0.00/5 (No votes)

See more:

ASP.NET4

How to add existing database in app_data folder in asp.net?

Posted 16-Aug-12 1:47am

veenusethi

Add a Solution

Comments

ridoy 16-Aug-12 7:59am

just cope and paste your_database.mdf file in app_data folder..

2 solutions

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)

veenusethi · Answer 1 · 2012-08-27T19:14:00

XML

1) first of all i have to deattach database from sql server
a) open sql server
b) connect your server
c) open node of database and right click on your database and choose task menu and then choose deattach then database will deattached

2) In second step in visual studio right click on app_data folder and click on add existing item and then select database which you want to add in app_data folder it will be in In my case ( C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\accountdb.mdf) and now this database will add in app_data folder

3) Now change your connection string in config file
Collapse | Copy Code

<connectionstrings>
        <add connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Accountdb.mdf;Integrated Security=True;User Instance=True  " name="ConnectionASPX" providername="System.Data.SqlClient" />
</connectionstrings>




//here |DataDirectory| is path of app_data folder and accountdb is the name of database name can be anything of connectionstring.

Thank You if this solution helps you so please vote for me

Raje_ · Answer 2 · 2012-08-16T02:06:00

Solution 1

So what is your problem just go ahead.
Right click on your App_Data folder and click on Add Existing Item,
Then select your database and that's it.

The given method works only when your database is detached with SqlServer.
For detaching the database go to your database in Sql Server and then right click on it and select detach option.
then find your database somewhere in c driver:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

All the best.

Posted 16-Aug-12 2:06am

Raje_

Comments

veenusethi 17-Aug-12 0:40am

Thanks for your reply it works

veenusethi 17-Aug-12 0:41am

But how to bind app_data folder's database with crystal reports

vihangshah 21-Feb-13 4:35am

but when we use this approach then i can not found database on server at the time of get the connection string or making the connection ???

Member 11631592 3-May-16 8:03am

but when I am trying to connect it is saying access denied