How to create database from codebehind in ASP.net 2.0?

Question

Hi all,

I need to create database from codebehind in ASP.net 2.0.

Please help.

Answer 1

May be like this:

SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand("CREATE DATABASE database_name", connection);
command.Connection.Open();
command.ExecuteReader();
connection.Close();