How change location of |DataDirectory| in ASP.NET application built in C# [duplicate]

Question

Possible Duplicate:
Using a relative path in connection string for Access DB in C#

This is my current connection string in web.config

<connectionStrings>
   <add name="dbConnection" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\GeauxEatAccessDB.accdb"/>
</connectionStrings>

but instead of looking in the App_Data folder, the application looks in

"C:\\Program Files (x86)\\Common Files\\Microsoft Shared\\DevServer\\10.0"

which isn't right. How and where can I change the default location of |DataDirectory| to be the relative path of App_Data inside the project folder?

platon · Accepted Answer · 2012-11-01 22:05:16Z

8

You need to call the AppDomain.SetData method to specify where the |DataDirectory| points to:

AppDomain.CurrentDomain.SetData("DataDirectory", "YourPath");

answered Nov 1, 2012 at 22:05

platon

5,3801 gold badge24 silver badges25 bronze badges

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

1 Comment

Un Known Over a year ago

Thanks for the help @platon, I looked into it a little more and used this line to get it working AppDomain.CurrentDomain.SetData("DataDirectory", Server.MapPath("~/App_Data/"));

Collectives™ on Stack Overflow

How change location of |DataDirectory| in ASP.NET application built in C# [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related