VB 程序设计

10个成员

.NET和VB编程创建SQL Server 置顶

发表于 2016-12-28 4069 次查看
  1.新建一个 Visual Basic .Net Windows 应用程序项目。默认情况下,将 Form1 添加到项目中。

  2.在 Form1 上放一个 Command 按钮,并将其 Name 属性更改为 btnCreateDatabase,将其 Text 属性更改为 Create Database。

  3.复制下面一行代码并粘贴到 Form1 的“general declaration”部分: Imports System.Data.SqlClient

  4.复制下面的代码并粘贴到“Windows Form Designer generated code”区域之后:  

  Private Sub btnCreateDatabase_Click(ByVal sender As System.Object, _
   ByVal e As System.EventArgs) Handles btnCreateDatabase.Click
   Dim reader As SqlDataReader
   Dim str As String
   Dim myConn As SqlConnection = New SqlConnection("Server=(local)\netsdk;" & _
   "uid=sa;pwd=;database=master") 

   str = "CREATE DATABASE MyDatabase ON PRIMARY " & _
   "(NAME = MyDatabase_Data, " & _
   " FILENAME = 'D:\MyFolder\MyDatabaseData.mdf', " & _
   " SIZE = 2MB, " & _
   " MAXSIZE = 10MB, " & _
   " FILEGROWTH = 10%) " & _
   " LOG ON " & _
   "(NAME = MyDatabase_Log, " & _
   " FILENAME = 'D:\MyFolder\MyDatabaseLog.ldf', " & _
   " SIZE = 1MB, " & _
   " MAXSIZE = 5MB, " & _
   " FILEGROWTH = 10%) "
   Dim myCommand As SqlCommand = New SqlCommand(str, myConn)
   Try
   myConn.Open()
   reader = myCommand.ExecuteReader()
   Catch ex As Exception
   MessageBox.Show(ex.ToString())
   Finally
   If Not reader Is Nothing Then
   reader.Close()
   If (myConn.State = ConnectionState.Open) Then
   myConn.Close()
   End If
   MessageBox.Show("Database is created successfully", _
   "MyProgram", MessageBoxButtons.OK, _
   MessageBoxIcon.Information)
   End If
   End Try
   End Sub 

  5.更改连接字符串使其指向 SQL Server,要确保将 Database 参数设置为 Master 或保留为空白。

  6.按 F5 键或 CTRL+F5 组合键以运行该项目,然后单击创建数据库。   

  其他注意事项   

  此代码创建的是带有特定属性的自定义数据库。  

  将要保存所创建 .mdf 和 .ldf 文件的文件夹必须在运行该代码之前就已存在、否则会引发异常。

  如果想创建一个类似于 SQL Server 的 Model 数据库的数据库并想让它存储在默认位置,那么请更改代码中的 str 变量: str = "CREATE DATABASE MyDatabase"

 

发表回复
你还没有登录,请先登录注册