Database in visual c#

Question

1.00/5 (1 vote)

See more:

I have a problem with my database project.
I have developed a database software in visual C#. I have used sql server database ( .mdf ).
The problem is _
when i shift my whole software to another directory connection to database is not possible.There occurs an error.Similarly if i move my software package to another pc the same problem occurs. The program only runs without error in the directory in which i developed it.
I know the problem is due to connection string. i have coded a fixed connection string but when directory changes the string remains unchanged. I need a way that the program automatic locate the database. What can i do? Please help.

Posted 3-Jul-12 20:39pm

faisal_ruet

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)

OriginalGriff · Answer 1 · 2012-07-03T21:10:00

If you have your database as SQL Server, then the connection string should be independent of the database location - it should refer to the SQL server instance, which is not accessed by a file system structure. Without seeing the code, and the connection string in particular, it is difficult to be sure, but I would guess that your SQL connection string is attaching the database each time, rather than letting SQL server handle the database itself, and referring to the specific database via the "Initial Catalog" specification in the connection string. This has a number of problems: the DB disk location become critical - if you move the DB or the app relative to the DB then it may well fail as you have seen. It also means that there is a good chance that each user will be using his own copy of the database instead of sharing the DB between them.

Let SQL server handle the database - and access it via the SQL instance instead of directly.

vangapally Naveen Kumar · Answer 2 · 2012-07-03T21:05:00

Solution 1

add like this in app.Config

XML

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

Posted 3-Jul-12 21:05pm

vangapally Naveen Kumar

Updated 3-Jul-12 21:08pm

v3