如何用代码实现在应用程序当前目录新建sql server数据库？

[sunshine_study]

RT。
假如我建库的代码是这样：

str = "CREATE DATABASE MyDatabase ON PRIMARY " + 
"(NAME = MyDatabase_Data, " + 
"FILENAME = 'C:\\MyDatabaseData.mdf', " + 
"SIZE = 2MB, MAXSIZE = 10MB, FILEGROWTH = 10%) " + 
"LOG ON (NAME = MyDatabase_Log, " + 
"FILENAME = 'C:\\MyDatabaseLog.ldf', " + 
"SIZE = 1MB, " + 
"MAXSIZE = 5MB, " + 
"FILEGROWTH = 10%)"; 

现在里边的“FILENAME =”应该怎么改，就能实现题目的要求？

[sunshine_study]

[Quote=引用 3 楼 的回复:]

引用 2 楼 的回复:

关于FILENAME的整段字符串，我是这样写的：
C# code

"FILENAME = Application.ExecutablePath+"+"\\MyDatabaseData.mdf,"


但是语法错误。不知道怎么回事？请教一下。


Application.ExecutablePath，获得包括应用程序名在内的最完整路径
后面，是……
[/Quote]
去掉其中一个\后报错：无法识别的转义序列：\M

[sunshine_study]

这样写：

string str = "CREATE DATABASE MyDatabase ON PRIMARY " +
           "(NAME = MyDatabase_Data, " +
           "FILENAME = '" + Application.ExecutablePath + "\\MyDatabaseData.mdf'," +
           "SIZE = 3MB, MAXSIZE = 10MB, FILEGROWTH = 10%) " +
           "LOG ON (NAME = MyDatabase_Log, " +
           "FILENAME = '" + Application.ExecutablePath+"\\MyDatabaseLog.ldf'," +
           "SIZE = 1MB, " +
           "MAXSIZE = 5MB, " +
           "FILEGROWTH = 10%)";

也不行，在Application.ExecutablePath处显示：当前上下文不存在名称Application

[bdmh]

当前目录，可以不写目录，直接写文件名，或者自己组合，用

Application.ExecutablePath+"\\xxxxx.mdf"
或
Application.StartupPath

[sunshine_study]

关于FILENAME的整段字符串，我是这样写的：

"FILENAME = Application.ExecutablePath+"+"\\MyDatabaseData.mdf,"

但是语法错误。不知道怎么回事？请教一下。

[Mirror然]

[Quote=引用 2 楼 的回复:]

关于FILENAME的整段字符串，我是这样写的：
C# code

"FILENAME = Application.ExecutablePath+"+"\\MyDatabaseData.mdf,"


但是语法错误。不知道怎么回事？请教一下。
[/Quote]

Application.ExecutablePath，获得包括应用程序名在内的最完整路径
后面，是什么意思 应该是\不是\\

[sunshine_study]

解决了，原来要使用Application.ExecutablePath，必须要用Windows Form项目作开发才行。

另外建库的语句写成：

           string str = "CREATE DATABASE MyDatabase ON PRIMARY " +
           "(NAME = MyDatabase_Data, " +
           "FILENAME = '" + Application.ExecutablePath + "\\MyDatabaseData.mdf'," +
           "SIZE = 3MB, MAXSIZE = 10MB, FILEGROWTH = 10%) " +
           "LOG ON (NAME = MyDatabase_Log, " +
           "FILENAME = '" + Application.ExecutablePath+"\\MyDatabaseLog.ldf'," +
           "SIZE = 1MB, " +
           "MAXSIZE = 5MB, " +
           "FILEGROWTH = 10%)";