C# Windows Application help required

Question

0.00/5 (No votes)

See more:

I am making a windows application,I have connection string in app.config like this

MSIL

<add name="Assignement1_2008.Properties.Settings.SummonsSoundsv1ConnectionString"
            connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\abc.accdb"
            providerName="System.Data.OleDb" />

The DB abc is located in solution of my project(ie root directory)

I want to use the DB which is located inside Debug folder

How can I Change the connection string of App.config??

Posted 6-Jun-11 20:17pm

Syed Salman Raza Zaidi

Add a Solution

Comments

Syed Salman Raza Zaidi 7-Jun-11 2:18am

I mean what should be used instead of [DataDirectory|?

4 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)

Uday P.Singh · Answer 1 · 2011-06-06T20:22:00

Solution 1

You can use this:

MSIL

<add name="Assignement1_2008.Properties.Settings.SummonsSoundsv1ConnectionString"
            connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=.\\abc.accdb"
            providerName="System.Data.OleDb" />

Hope this help :)

Posted 6-Jun-11 20:22pm

Uday P.Singh

Ciumac Sergiu · Answer 2 · 2011-06-06T20:31:00

Solution 2

Hi,
there is an entire resource specifically available for connection strings settings.
It can be found: here[^]. There are plenty of examples how you can attach a database to the application, by pointing to a specific file rather than server path.
Regards

Posted 6-Jun-11 20:31pm

Ciumac Sergiu

Ramalinga Koushik · Answer 3 · 2011-06-06T20:41:00

Solution 3

Use directly instead of DataDirectory.

<add name="Assignement1_2008.Properties.Settings.SummonsSoundsv1ConnectionString"
            connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=.\\abc.accdb"
            providerName="System.Data.OleDb" />

This will solve your problem.

Posted 6-Jun-11 20:41pm

Ramalinga Koushik

parmar_punit · Answer 4 · 2011-06-06T23:01:00

actually when you use |DataDirectory| in database connection string,
it automatically maps the path from where your application is started...

so when you debug or run your program by pressing F5 in Visual Studio, it runs from debug folder path so it will automatically map the database which is copied in debug folder...

That database is copied each and every time you compile the code, if you have default setting for that......

so if you want to map the database which is in your current directory or solution then you have to give static path uptill you developing it.... At last before publishing it, you must replace static path with |DataDirectory|.......

For more detail visit
http://www.connectionstrings.com/

Thanks & Regards,
Punit