.net – 如何在SQL Server中以编程方式创建数据库?

前端之家收集整理的这篇文章主要介绍了.net – 如何在SQL Server中以编程方式创建数据库?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
如何从C#应用程序创建新数据库

我假设一旦我创建它,我可以简单地生成连接字符串并连接到它,并发出所有CREATE TABLE语句.

解决方法

KB307283解释了如何使用ADO.NET创建数据库.

来自文章

String str;
sqlConnection myConn = new sqlConnection ("Server=localhost;Integrated security=SSPI;database=master");

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

sqlCommand myCommand = new sqlCommand(str,myConn);
try 
{
    myConn.Open();
    myCommand.ExecuteNonQuery();
    MessageBox.Show("DataBase is Created Successfully","MyProgram",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch (System.Exception ex)
{
    MessageBox.Show(ex.ToString(),MessageBoxIcon.Information);
}
finally
{
    if (myConn.State == ConnectionState.Open)
    {
        myConn.Close();
    }
}

猜你在找的MsSQL相关文章