please help me to correct C# DB connectivity code

Question

0.00/5 (No votes)

See more:

con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=global::motion.Resources.db_imageDataSet;Integrated Security=True;Connect Timeout=30;User Instance=True");

is it correct
here i have used sqlserver DB
and its file is
C:\Users\r\Desktop\final output\latest Rcar - Copy\motion\Resources\db_image.mdf

so how can correct it

Posted 23-Mar-11 7:37am

vishnulalr

Updated 23-Mar-11 7:38am

Wendelius

v2

Add a Solution

Comments

Wendelius 23-Mar-11 13:39pm

What error are you getting?

Sandeep Mewara 23-Mar-11 13:42pm

Any error? What?

vishnulalr 23-Mar-11 13:42pm

error is already existing same DB file

vishnulalr 23-Mar-11 13:43pm

here i want to connect the DB file from the resource folder from the project itself.In ordinary case DB file is put in a local folder and reference it using its path
and i want to avoid that
so how can i modify my above code

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)

Wendelius · Answer 1 · 2011-03-23T07:46:00

Solution 1

If the database is already attached, go to Management Studio and detach the database from the SQL Server instance. After that your code should be able to attach the database when you run it.

Posted 23-Mar-11 7:46am

Wendelius

Pavel Yermalovich · Answer 2 · 2011-03-23T07:55:00

Solution 2

Developers community number 1 connection string reference

Posted 23-Mar-11 7:55am

Pavel Yermalovich