How to create a MSDE Database

[ad]

How to create a MSDE Database with C#?

[DalePres]

Just connect to the Master database and execute a CREATE DATABASE statement.
Here's a working example but remember that the SQL and the C# code are both
in their most basic form. You should flush them both out before building it
into your application:

using(SqlConnection conn = new
SqlConnection("Server=localhost;Database=master;In tegrated Security=SSPI"))

{

// create the command

SqlCommand cmd = conn.CreateCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "CREATE DATABASE TestDB";

// create the database

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

}

HTH

DalePres

MCAD, MCDBA, MCSE

"ad" <[e-mail]> wrote in message
news:up**************@TK2MSFTNGP15.phx.gbl...

How to create a MSDE Database with C#?