C#自動建立資料庫實現代碼

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class slu1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (execfile())
{
Response.Write("Success");
}
}
}

/// <summary>
/// 建立串連起用進程建立資料庫
/// </summary>
/// <returns></returns>
private bool execfile()
{
try
{
string connStr = "data source=127.0.0.1;user id=sa;password=sa;persist security info=false;packet size=4096";

ExecuteSql(connStr, "master", "CREATE DATABASE" + " SqlTest");//調用ExecuteNonQuery()來建立資料庫

System.Diagnostics.Process sqlProcess = new System.Diagnostics.Process();//建立一個進程

sqlProcess.StartInfo.FileName = "osql.exe";//OSQL基於ODBC驅動串連伺服器的一個工具 + 生產力（可查閱SQL協助手冊）
//string str = @"C:\Program Files\Microsoft SQL Server\MSSQL\Data";

sqlProcess.StartInfo.Arguments = " -U sa -P sa -d SqlTest -i C:\\Program Files\\Microsoft SQL Server\\MSSQL\\Data";//擷取啟動程式時的參數
sqlProcess.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;//調用進程的視窗狀態，隱藏為後台
sqlProcess.Start();
sqlProcess.WaitForExit();
sqlProcess.Close();
return true;
}
catch (Exception ex)
{
throw ex;
}
}

/// <summary>
/// 建立資料庫，調用ExecuteNonQuery()執行
/// </summary>
/// <param name="conn"></param>
/// <param name="DatabaseName"></param>
/// <param name="Sql"></param>
private void ExecuteSql(string conn, string DatabaseName, string Sql)
{
System.Data.SqlClient.SqlConnection mySqlConnection = new System.Data.SqlClient.SqlConnection(conn);
System.Data.SqlClient.SqlCommand Command = new System.Data.SqlClient.SqlCommand(Sql, mySqlConnection);
Command.Connection.Open();
Command.Connection.ChangeDatabase(DatabaseName);
try
{
Command.ExecuteNonQuery();
}
finally
{
Command.Connection.Close();
}
}
}