How to change final database files path

Question

4.00/5 (1 vote)

See more:

How to change final database files path reading and setting them from access to codes necessary field?
Also I want to set this paths in win form and save it in access

svo_dirInf = new DirectoryInfo(Environment.CurrentDirectory);
svo_dirDBFiles = svo_dirInf.FullName;

svo_dirDB = svo_dirDBFiles + "DB_Files\\Allfiles.mdb";
svo_dirOS = svo_dirDBFiles + "OS";
svo_dirDBFiles = svo_dirDBFiles + "DB_Files";

and I have access table like this

Name Value
OS D:\Server\Day_OS
DB_Server D:\Server\DB_Files
OS_Server D:\Server\OS
svo_File D:\Server\OS\20

I want read name and set value

Also I have FolderBrowserDialog in new opening form where in textboxes I want to set new Paths for files
So the current directory will be changed the path which I set in new form

What I have tried:

to change final database files path

Posted 18-May-20 1:01am

Member 14734812

Updated 18-May-20 1:28am

v4

Add a Solution

Comments

OriginalGriff 18-May-20 7:08am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with. And what you have typed means nothing to me without context.

Try explaining exactly what you have as inputs, and exactly what you expect to get as outputs - that may help.

Use the "Improve question" widget to edit your question and provide better information.

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)

RickZeeland · Accepted Answer · 2020-05-18T01:22:00

Solution 1

Take a look at:
Path Class (System.IO) | Microsoft Docs[^]
Directory Class (System.IO) | Microsoft Docs[^]

It's better to use Path.Combine() to concatenate paths: Path.Combine Method (System.IO) | Microsoft Docs[^]

Posted 18-May-20 1:22am

RickZeeland

Comments

Member 14734812 18-May-20 7:37am

Thanks

phil.o · Accepted Answer · 2020-05-18T01:28:00

You should build your paths using the Path.Combine method. It will automatically take care of path separators for you.

C#

string basePath = @"C:\ProgramData";

// appDir == @"C:\ProgramData\MyApp"
string appDir = Path.Combine(basePath, "MyApp");

// dbDir == @"C:\ProgramData\MyApp\DB"
string dbDir = Path.Combine(appDir, "DB");

// osDir == @"C:\ProgramData\MyApp\OS"
string osDir = Path.Combine(appDir, "OS");

// dbFile == @"C:\ProgramData\MyApp\DB\Allfiles.mdb"
string dbFile = Path.Combine(dbDir, "Allfiles.mdb");

Also note the extra @ in front of the opening double-quote for the string declaration. It tells the compiler that backslash should not be interpreted as an escape character as it would normally do, but rather as the literal backslash character itself. It allows for specifying paths without the need to double the backslashes:

C#

string basePath = @"C:\ProgramData";
// is equivalent to
string basePath = "C:\\ProgramData";

Regarding the database-storage part, you can save any path, or part of a path, as a string.

Finally, if you want to change the path of the database in the application, you have to do it before connecting to the database. If there is an active connection, you would have to close it, change the path, and then open the connection on the new database.