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;Integrated 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