【VC开源代码栏目提醒】:以下是网学会员为您推荐的VC开源代码-SQLCreateDatabase.cpp,希望本篇文章对您学习有所帮助。
// 这是使用应用程序向导生成的 VC++
// 应用程序项目的主项目文件。
#include "stdafx.h"
#using <mscorlib.dll> //支持控制台程序的库
using namespace System;
#using <system.dll>
using namespace System;
#using <System.data.dll> //支持SQL Server .
NET Framework 数据提供
程序的库
using namespace System::Data;
using namespace System::Data::SqlClient;
#using <system.windows.forms.dll>//支持窗体的库
using namespace System::Windows::Forms;
//主程序
int _tmain()
{
Console::WriteLine(S"(1)输入'C'或'c'后,按回车键创建一个数据库");
Console::WriteLine(S"(2)按任何键和回车键,退出程序");
char c = Console::Read();
if (c == 'C' || c == 'c')
{
Console::WriteLine(S"正在创建数据库...");
String* str;
//需要注意的是在下面的连接字符串中需要输入用户名和密码,否则创建
//会失败,不过可以通过其它方式获取这两个字符串,不一定在程序中写定
SqlConnection* myConn = new SqlConnection
("Server=localhost;Integrated security=SSPI;database=;"
"UID=sa;PWD=");
str = "CREATE DATABASE TestDatabase ON PRIMARY "
"(NAME = TestDatabase_Data, "
"FILENAME = 'E:\\TestDatabaseData.mdf', "
"SIZE = 2MB, MAXSIZE = 10MB, FILEGROWTH = 10%) "
"LOG ON (NAME = TestDatabase_Log, "
"FILENAME = 'E:\\TestDatabaseLog.ldf', "
"SIZE = 1MB, "
"MAXSIZE = 5MB, "
"FILEGROWTH = 10%)";
try
{
SqlCommand* myCommand = new SqlCommand(str, myConn);
myConn->Open();
myCommand->ExecuteNonQuery();
MessageBox::Show("成功地创建了数据库","TestSQLCreateDatabaseProgram", MessageBoxButtons::OK,
MessageBoxIcon::Information);
}
catch (System::Exception* ex)
{
MessageBox::Show(ex->ToString(), "TestSQLCreateDatabaseProgram",
MessageBoxButtons::OK,
MessageBoxIcon::Information);
}
if (myConn->State == ConnectionState::Open)
{
myConn->Close();
}
}
return 0;
}