如何创建一个数据库文件????????
ccbl 2003-04-09 12:29:19 Dim Fi As String
Dim fi_ldf As String
Fi = "e:\" & n & ".mdf"
fi_ldf = "e:\" & n & ".ldf"
'定义生成的记录集合
Dim Createsql As New ADODB.Recordset
Dim SQLCreate As String
SQLCreate = "create database " & n & "" & vbCrLf & "on" & vbCrLf & _
"primary(name=" & n & "_data, filename='" & Fi & "', size=20MB, " & _
"maxsize=30MB, filegrowth=20%)" & vbCrLf & _
"log on" & vbCrLf & "(name=System_log, filename='" & fi_ldf & "', " & _
"size=3MB, " & vbCrLf & "maxsize=5MB, filegrowth=1MB)"
Set Createsql = CreatSqlFiles.Execute(SQLCreate, 1, adCmdText)
Set Createsql = Nothing
CreatSqlFiles.Close
Set CreatSqlFiles = Nothing
以上为VB6。0+ADO 2。5 创建一个MS SQL文件,在VB。NET中使用ADO。NET如何创建一个数据库文件