2.在Form1上放一個Command按鈕,并將其Name屬性更改為btnCreateDatabase,將其Text屬性更改為CreateDatabase。
3.復制下面一行代碼并粘貼到Form1的“generaldeclaration”部分:ImportsSystem.Data.SqlClient
4.復制下面的代碼并粘貼到“WindowsFormDesignergeneratedcode”區域之后:
PRivateSubbtnCreateDatabase_Click(ByValsenderAsSystem.Object,_
ByValeAsSystem.EventArgs)HandlesbtnCreateDatabase.Click
DimreaderAsSqlDataReader
DimstrAsString
DimmyConnAsSqlConnection=NewSqlConnection("Server=(local)/netsdk;"&_
"uid=sa;pwd=;database=master")
str="CREATEDATABASEMyDatabaSEONPRIMARY"&_
"(NAME=MyDatabase_Data,"&_
"FILENAME='D:/MyFolder/MyDatabaseData.mdf',"&_
"SIZE=2MB,"&_
"MAXSIZE=10MB,"&_
"FILEGROWTH=10)"&_
"LOGON"&_
"(NAME=MyDatabase_Log,"&_
"FILENAME='D:/MyFolder/MyDatabaseLog.ldf',"&_
"SIZE=1MB,"&_
"MAXSIZE=5MB,"&_
"FILEGROWTH=10)"
DimmyCommandAsSqlCommand=NewSqlCommand(str,myConn)
Try
myConn.Open()
reader=myCommand.ExecuteReader()
CatchexAsException
MessageBox.Show(ex.ToString())
Finally
IfNotreaderIsNothingThen
reader.Close()
If(myConn.State=ConnectionState.Open)Then
myConn.Close()
EndIf
MessageBox.Show("Databaseiscreatedsuccessfully",_
"MyProgram",MessageBoxButtons.OK,_
MessageBoxIcon.Information)
EndIf
EndTry
EndSub
5.更改連接字符串使其指向SQLServer,要確保將Database參數設置為Master或保留為空白。
6.按F5鍵或CTRL F5組合鍵以運行該項目,然后單擊創建數據庫?! ?/p>
其他注意事項
此代碼創建的是帶有特定屬性的自定義數據庫。
將要保存所創建.mdf和.ldf文件的文件夾必須在運行該代碼之前就已存在、否則會引發異常。
如果想創建一個類似于SQLServer的Model數據庫的數據庫并想讓它存儲在默認位置,那么請更改代碼中的str變量:str="CREATEDATABASEMyDatabase"
->新聞熱點
疑難解答