usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Collections;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
publicpartialclassslu1:System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
if(!IsPostBack)
{
if(execfile())
{
Response.Write("Success");
}
}
}
///<summary>
///创建连接起用进程建立数据库
///</summary>
///<returns></returns>
privateboolexecfile()
{
try
{
stringconnStr="datasource=127.0.0.1;userid=sa;password=sa;persistsecurityinfo=false;packetsize=4096";
ExecuteSql(connStr,"master","CREATEDATABASE"+"SqlTest");//调用ExecuteNonQuery()来创建数据库
System.Diagnostics.ProcesssqlProcess=newSystem.Diagnostics.Process();//创建一个进程
sqlProcess.StartInfo.FileName="osql.exe";//OSQL基于ODBC驱动连接服务器的一个实用工具（可查阅SQL帮助手册）
//stringstr=@"C:ProgramFilesMicrosoftSQLServerMSSQLData";
sqlProcess.StartInfo.Arguments="-Usa-Psa-dSqlTest-iC:ProgramFilesMicrosoftSQLServerMSSQLData";//获取启动程序时的参数
sqlProcess.StartInfo.WindowStyle=System.Diagnostics.ProcessWindowStyle.Hidden;//调用进程的窗口状态，隐藏为后台
sqlProcess.Start();
sqlProcess.WaitForExit();
sqlProcess.Close();
returntrue;
}
catch(Exceptionex)
{
throwex;
}
}
///<summary>
///创建数据库，调用ExecuteNonQuery()执行
///</summary>
///<paramname="conn"></param>
///<paramname="DatabaseName"></param>
///<paramname="Sql"></param>
privatevoidExecuteSql(stringconn,stringDatabaseName,stringSql)
{
System.Data.SqlClient.SqlConnectionmySqlConnection=newSystem.Data.SqlClient.SqlConnection(conn);
System.Data.SqlClient.SqlCommandCommand=newSystem.Data.SqlClient.SqlCommand(Sql,mySqlConnection);
Command.Connection.Open();
Command.Connection.ChangeDatabase(DatabaseName);
try
{
Command.ExecuteNonQuery();
}
finally
{
Command.Connection.Close();
}
}
}
【C#自动创建数据库实现代码】相关文章：
★ c#中的浮点型转整形的舍取 四舍五入和银行家舍入实现代码
★ winfrom 打印表格 字符串的封装实现代码 附源码下载