快捷導(dǎo)航

C#自動(dòng)創(chuàng)建數(shù)據(jù)庫(kù)實(shí)現(xiàn)代碼

更新時(shí)間：2008年03月09日 20:00:50 作者：

C#下創(chuàng)建數(shù)據(jù)庫(kù)的代碼

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>
    /// 創(chuàng)建連接起用進(jìn)程建立數(shù)據(jù)庫(kù)
    /// </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");//調(diào)用ExecuteNonQuery()來(lái)創(chuàng)建數(shù)據(jù)庫(kù)

            System.Diagnostics.Process sqlProcess = new System.Diagnostics.Process();//創(chuàng)建一個(gè)進(jìn)程

            sqlProcess.StartInfo.FileName = "osql.exe";//OSQL基于ODBC驅(qū)動(dòng)連接服務(wù)器的一個(gè)實(shí)用工具（可查閱SQL幫助手冊(cè)）
            //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";//獲取啟動(dòng)程序時(shí)的參數(shù)
            sqlProcess.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;//調(diào)用進(jìn)程的窗口狀態(tài)，隱藏為后臺(tái)
sqlProcess.Start();
            sqlProcess.WaitForExit();
            sqlProcess.Close();
            return true;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    /// <summary>
    /// 創(chuàng)建數(shù)據(jù)庫(kù)，調(diào)用ExecuteNonQuery()執(zhí)行
    /// </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();
        }
    }
}

您可能感興趣的文章: