C#自动创建数据库实现代码
发布时间:2010年01月23日点击数:
次未知
- 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\");
- }
- }
- }
-
-
-
-
- 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\");
- System.Diagnostics.Process sqlProcess = new System.Diagnostics.Process();
- sqlProcess.StartInfo.FileName = \"osql.exe\";
-
-
- 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;
- }
- }
-
-
-
-
-
-
- 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();
- }
- }
- }