使用ADO.NET和C#以编程方式创建 SQL Server 数据库

最新推荐文章于 2022-11-21 15:39:08 发布

最新推荐文章于 2022-11-21 15:39:08 发布 · 175 阅读

文章标签：

#SQL Server #编程 #C #C++ #C#

[网站分类]2..NET新手区(用于发表不合适发表在首页的.NET技术文章同时被 2 个专栏收录

17 篇文章

订阅专栏

包括小经验、小技巧)

17 篇文章

订阅专栏

本文介绍如何使用C#和SqlConnection在SQL Server中创建一个名为MyDatabase的新数据库，包括定义数据文件和日志文件的位置、初始大小及最大大小。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//Create Button on Form
//using System.data.sqlclient;

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(), "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
    finally
    {
    if (myConn.State == ConnectionState.Open)
    {
        myConn.Close();
    }
    }