如何在代碼中產生資料庫?

先串連到master資料庫, 然後執行建立資料庫的sql語句, 就可以了.

範例程式碼如下:

void button_Click(object sender, RoutedEventArgs e)

 {

   string connectionString = "Data Source=192.168.0.8;Initial Catalog=master;"

                +"Persist Security Info=True;User ID=sa;Password=sa";

            SqlConnection m_sqlConn = new SqlConnection(connectionString);

 

            string strCommand = "USE master;    IF DB_ID (N'mytest') IS NOT NULL      DROP DATABASE mytest;  CREATE DATABASE mytest;  SELECT name, size, size*1.0/128 AS [Size in MBs]  FROM sys.master_files WHERE name = N'mytest';";

 

 

           SqlCommand command = new SqlCommand(strCommand,m_sqlConn);

            m_sqlConn.Open();

            command.ExecuteNonQuery();

            m_sqlConn.Close();

        }