how to provide relative path in C#

Question

0.00/5 (No votes)

See more:

VS2008

My application is LAN based.I want to provide the path of access database relative where every machine can access that database which is on server machine.
AND also when i am moving application on another machine then i have to change my source path manually every time then what is solution..
I try following and previous code is.please help me.Thanks

conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\vishal_WPF_Final\MTDLL_TEACHER\MTDLL_TEACHER\student.mdb";

and i try like this too:

conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=student.mdb";

Posted 17-May-11 20:05pm

vishal_h

Updated 17-May-11 20:18pm

v3

Add a Solution

4 solutions

Solution 1

try on this links

http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection.connectionstring(v=vs.80).aspx[^]

http://www.w3schools.com/ADO/prop_conn_connectionstring.asp[^]

http://lamahashim.blogspot.com/2009/06/c-sql-server-connection-string.html[^]

Posted 17-May-11 20:11pm

jcosep

Comments

RaviRanjanKr 10-Nov-11 6:18am

My 5+

Solution 2

I dont think you need to worry about the relative path. First, make sure that your access database is placed in a central location accessible to all machines (i.e. Windows allows you to access this file).

Once that is done, you can look at defining the relative path or set up a connection string.

Posted 17-May-11 20:15pm

Abhinav S

Comments

vishal_h 18-May-11 2:16am

sir thanks but when i am moving my application to another machine then i want to change the path every time..so what is solution

Abhinav S 18-May-11 2:24am

The best you can do is set the path in a configuration file or settings file - if you are going to move the database very often. Read the settings file and then open the connection.

vishal_h 18-May-11 3:04am

but sir its not working my application is in WPF ..can you tel me please what i have to write in data source=...

vishal_h 18-May-11 3:28am

Sir i have done by copy that database file in debug folder and given the path in
string path = AppDomain.CurrentDomain.SetupInformation.ApplicationBase ;
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+path +@"\student.mdb";

Wonde Tadesse 9-Nov-11 12:05pm

My 5+

Solution 3

me too having same problem about relative path in WPF...
anybody..
please help

Posted 9-Nov-11 5:03am

rites_xz

Comments

Marc A. Brown 9-Nov-11 12:08pm

You need to post your problem, with specifics, as a separate question.

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)

Wonde Tadesse · Accepted Answer · 2011-11-09T06:05:00

Solution 4

In addition to Abhinav S solution, make sure the folder that contains the database is shared and has read/write access permission. So user will able to access it without difficulty.

Posted 9-Nov-11 6:05am

Wonde Tadesse