C# mdf connection-string sql-server-2008-express

上级文件夹中的连接字符串 mdf 文件

发布于 2025-01-03 18:02:13 字数 411 浏览 0 评论 0原文

我有以下连接字符串：

string connectionstr = "Data Source=.\\SQLEXPRESS;" + "AttachDbFilename=|DataDirectory|\\..\\..\\Datenbank\\FarmersCalc.mdf;" + "Integrated Security=True;" + "User Instance=true;";

据我所知， |DataDirectory| 是 /bin/debug- 文件夹。 mdf 文件位于文件夹 Datanbank 中，这肯定位于我在连接字符串中输入的文件夹中。

看来， ..\\ 不起作用。有人有解决这个问题的办法吗？

原文

I´ve got the following connectionstring:

string connectionstr = "Data Source=.\\SQLEXPRESS;" + "AttachDbFilename=|DataDirectory|\\..\\..\\Datenbank\\FarmersCalc.mdf;" + "Integrated Security=True;" + "User Instance=true;";

As i know, |DataDirectory| is the /bin/debug- folder.
The mdf file is in the folder Datenbank, that is for sure in the folder that I typed in in the connection string.

It seems, as ..\\ would not work.
Does anybody have a solution for that problem?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

听闻余生 2025-01-10 18:02:13

您可以使用以下代码计算目录。

//these two lines get the executable's directory
Uri u = new Uri(Assembly.GetExecutingAssembly().GetName().CodeBase);
DirectoryInfo d = new DirectoryInfo(Path.GetDirectoryName(u.LocalPath));

//this goes up two directories and combines that directory with the rest
//of the path to the file
string path = Path.Combine(d.Parent.Parent.FullName, @"Datenbank\FarmersCalc.mdf;");
Console.WriteLine(path);

You could just calculate the dir using the following code.

//these two lines get the executable's directory
Uri u = new Uri(Assembly.GetExecutingAssembly().GetName().CodeBase);
DirectoryInfo d = new DirectoryInfo(Path.GetDirectoryName(u.LocalPath));

//this goes up two directories and combines that directory with the rest
//of the path to the file
string path = Path.Combine(d.Parent.Parent.FullName, @"Datenbank\FarmersCalc.mdf;");
Console.WriteLine(path);

回复收藏 0 原文

~没有更多了~