数据库安装代码

最新推荐文章于 2022-06-14 11:35:46 发布

jxufewbt

最新推荐文章于 2022-06-14 11:35:46 发布

阅读量1.2k

点赞数

分类专栏： C# 文章标签：数据库 string exception security database command

本文链接：https://blog.csdn.net/jxufewbt/article/details/851722

版权

C# 专栏收录该内容

287 篇文章 1 订阅

订阅专栏

private void ExecuteSql(string conn, string DatabaseName, string Sql)
  {
   SqlConnection mySqlConnection = new SqlConnection(conn);
   SqlCommand Command = new SqlCommand(Sql, mySqlConnection);
   mySqlConnection.Open();
   mySqlConnection.ChangeDatabase(DatabaseName);
   try
   {
    Command.ExecuteNonQuery();
   }
   finally
   {
    Command.Connection.Close();
   }
  }

  public void Install(string serveraddress, string username, string password, string databasename, string databasepath, string webpath)
  {
   try
   {
    string connStr = string.Format("data source={0};user id={1};password={2};persist security info=false;packet size=4096", serveraddress, username, password);
    ExecuteSql(connStr, "master", "CREATE DATABASE " + databasename);
    System.Diagnostics.Process sqlProcess = new System.Diagnostics.Process();
    sqlProcess.StartInfo.FileName = "osql.exe ";
    string osqlstring;
    sqlProcess.StartInfo.Arguments = string.Format(" -U " + username + " -P " + password + " -d " + databasename + " -i " + databasepath + "//db.sql");
    sqlProcess.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
    sqlProcess.Start();
    sqlProcess.WaitForExit();
    sqlProcess.Close();
   }
   catch (Exception ex)
   {
    throw ex;
   }
}