Attach Database file, conncetion String

Question

0.00/5 (No votes)

See more:

I have a project in C#.net ,Visul studio-2008 with database in SQL Server-2008.It is windows application project.

I have create a folder named 'Data' in Debug folder. & I copy and paste data base .mdf and ldf file into 'Data' folder

Now i want to connect databse in 'Data' Folder .
I have a code for connection string
"
sqlcon = new SqlConnection(@"Data Source='.\SQLExpress'; Initial Catalog=; Integrated Security=true; AttachDBFileName='" +Application.StartupPath+@"\Data\Laboratory1.mdf; Uid=sa;Pwd=zxc'");
"
but its not working.I got an error at execution time;

So i want to know
what is the connection string when the database copy paste in Data Folder with in debug folder?

Please help me.

Posted 9-Oct-12 20:08pm

Member 8470112

Updated 9-Oct-12 20:41pm

v2

Add a Solution

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)

Sarvesh Kushwaha · Answer 1 · 2012-10-09T20:39:00

Dear you should have Sql sever express to run these .
then create your database in App_code .

for your reference connection string will be -

XML

<connectionStrings>
      <add name="DatabaseConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=true" providerName="System.Data.SqlClient"/>
   </connectionStrings>

for windows you can use this

C#

Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname;
Trusted_Connection=Yes;

OriginalGriff · Answer 2 · 2012-10-09T20:49:00

Seriously? I wouldn't do that, as it relies on the eventual production program having permission to write files on the folder, which will be below the "Program Files" folder, which is normally restricted to Admin only. You will probably be getting the same permissions problem here.

Instead, keep your database in a more accessible place - see here: Where should I store my data?[^]

Attach Database file, conncetion String

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0