Building an Access connection string using .NET to find the current directory>

Question

I have a line of code that builds the connection string to an Access database.

private static string ConnectionString = 
            @"Provider=Microsoft.Jet.OLEDB.4.0;" + 
            @"Data source= C:\Documents and Settings\username\My Documents\AccessFile.mdb";

How can I use any of these bits of code: Path.GetDirectoryName() or System.Environment.CurrentDirectory?

System.IO.Path.GetDirectoryName(System.Environment.CurrentDirectory)

Kirk Woll · Accepted Answer · 2012-05-19 01:39:50Z

4

It's not clear where in the string you'd like to insert this, but I'll assume you want to replace the entire directory path. To do this, you could just concatenate the strings together using +:

private static string ConnectionString = 
    @"Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + 
    System.IO.Path.GetDirectoryName(System.Environment.CurrentDirectory) +
    @"\AccessFile.mdb";

Alternatively (and probably better) would be to use string.Format:

private static string ConnectionString = string.Format(
    @"Provider=Microsoft.Jet.OLEDB.4.0;Data source={0}\AccessFile.mdb", 
    System.IO.Path.GetDirectoryName(System.Environment.CurrentDirectory));

answered May 19, 2012 at 1:39

Kirk Woll

77.8k23 gold badges189 silver badges200 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ariel Mazin Over a year ago

i vey surprised for the quick answer i going to try it soon

Krishanu Dey · Accepted Answer · 2012-05-19 01:41:29Z

0

Try Using

using System.Linq; 
using System.Text; 
using System.Data; 
using System.Data.OleDb;

namespace DAL 
{
    public class OLEDBhelper
    {
        private static string ConnectionString = 
            @"Provider=Microsoft.Jet.OLEDB.4.0;" + 
            @"Data source= " + System.IO.Path.GetDirectoryName(System.Environment.CurrentDirectory) + "\AccessFile.mdb";
    }
}

answered May 19, 2012 at 1:41

Krishanu Dey

6,4067 gold badges53 silver badges69 bronze badges

Collectives™ on Stack Overflow

Building an Access connection string using .NET to find the current directory>

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related