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

RT。我建了两次代码都不行,求大家指教,代码应该如何改
我建库的代码是这样子的:

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

改为:

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%)";

也不行。

一只甜甜圈
浏览 508回答 1
1回答

青春有我

是什么类型的程序(webform 或 winform)是否引用了“using System.Windows.Forms;”这个命名空间,写法应该是第一种,你断点调试一下
打开App,查看更多内容
随时随地看视频慕课网APP

相关分类

SQL Server