create database with asp.net

[Marina]

Odds are, it won't be able to execute everything in your script. For
example, it won't handle GO statements too well.

You should use SQLDMO to run the script instead, this will be like using
query analyzer.

 

[Luis Esteban Valencia]

Hello. I want to create a sql server database with my asp.net program. It
will have a textbox for server , other for username and other for password,
after it the program must execute a .sql file. Is that possible?

 

[Luis Esteban Valencia]

but how! It must be done from the asp.net page as DOTNETNUKE installation
does.

 

[jasonkester]

Nothing stopping you from treating that .sql file as a "GO" delimited
list of SQL statements that you can run in series.

And for what it's worth, DNN does not actually call CREATE DATABASE.
It needs you to create a database and tell it the name. It just builds
the tables the first time you run it.

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/

 

[Marina]

I've had trouble doing that. There are still things ADO.NET chokes on, even
if you break things apart by GO statements.