Create a new database programatically?

I may not be fully understanding the issue...

BobP

BobP1339 at 2007-9-8 >

First, connecto to the master database using a SqlConnection objejct. Then Execute the T-Sql with SqlCommand Object. I haven't personally tried it but I think t-sql could be used in sqlexpress...

Dim sqlCon As New SqlConnection("Password=;Persist Security Info=True;User ID=sa;Initial Catalog=master;Data Source=local")
sqlCon.Open()
Dim cmd As New SqlCommand("CREATE DATABASE dbase1", sqlCon)
cmd.ExecuteNonQuery()

Ypu can the connect to the database that you created and create your tables.
cheers,

Paul June A. Domag

PaulDomag at 2007-9-8 >