小弟想在visual studio 2005中动态创建数据库并创建表,但是在创建前检查是否已存在该数据库,如果存在提示是删除还是不删除?
我想到用下面的SQL语句来完成,在SQL中可以执行,但在visual studio 2005中如何用代码完成呢?
CREATE DATABASE MyDataBase
drop database MyDataBase
...全文
662打赏收藏
动态创建SQL数据库
小弟想在visual studio 2005中动态创建数据库并创建表,但是在创建前检查是否已存在该数据库,如果存在提示是删除还是不删除? 我想到用下面的SQL语句来完成,在SQL中可以执行,但在visual studio 2005中如何用代码完成呢? CREATE DATABASE MyDataBase drop database MyDataBase
Private Sub 创建数据库_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles 创建数据库.Click
conn = New SqlConnection(ConnectionString)
If conn.State <> ConnectionState.Open Then
conn.Open()
End If
sql = "CREATE DATABASE MyDataBase ON PRIMARY (Name=MyDataBase_data, filename = " + "'H:\MyDataBase.mdf', size=3," + "maxsize=5, filegrowth=10%) log on" + "(name=MyDataBase_log, " + "filename='H:\MyDataBase.ldf',size=3," + "maxsize=20,filegrowth=1)"
cmd = New SqlCommand(sql, conn)
Try
cmd.ExecuteNonQuery()
Catch ae As SqlException
If MsgBox("数据库已经存在,是否删除?", MsgBoxStyle.OkCancel, "检查数据库是否存在") = MsgBoxResult.Ok Then
sql = "drop database MyDataBase"
cmd = New SqlCommand(sql, conn)
cmd.ExecuteNonQuery()
End If
End Try
End Sub