AutoCAD 3DMAX C语言 Pro/E UG JAVA编程 PHP编程 Maya动画 Matlab应用 Android
Photoshop Word Excel flash VB编程 VC编程 Coreldraw SolidWorks A Designer Unity3D
 首页 > VB编程

.NET和VB编程创建SQL Server

51自学网 http://www.wanshiok.com
  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"

 

 

 
上一篇:用VB实现任意修改Win桌面背景  下一篇:Visual Basic 安装程序的制作