C#执行.sql文件,创建数据库。SQLSERVER

C#执行.sql文件,创建数据表

参考此路径写的: 引用路径.
创建数据库语句【CREATE DATABASE】不在sql文件中

直接上创建按钮代码：

// 样列：
 /// <summary>
        /// 创建数据库
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            try
            {
                //先连接默认的数据库master
                string serverUrl = $"Server={textEdit_IP.Text};Database=master;uid={textEdit_uid.Text};pwd={textEdit_pwd.Text}";
                SqlConnection mySqlConnection = new SqlConnection(serverUrl);
                if (mySqlConnection.State==ConnectionState.Open)
                {
                    mySqlConnection.Close();
                }
                mySqlConnection.Open();
                //查询要创建的数据库名是否存在？
                string sqlSelect = $@"select * from master.dbo.sysdatabases where name='{textEdit_dbname.Text}'";
                SqlDataAdapter sda = new SqlDataAdapter(sqlSelect, mySqlConnection);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                if (dt.Rows.Count>0&&dt!=null)
                {
                    XtraMessageBox.Show($"{textEdit_dbname.Text}已经存在此数据库！");
                }
                else
                {
                    //不存在，就创建数据库
                    string sql =$@"CREATE DATABASE {textEdit_dbname.Text}";
                    SqlConnection sqlConnection = new SqlConnection(serverUrl);
                    SqlCommand Command = new SqlCommand(sql, sqlConnection);
                    Command.Connection.Open();
                    Command.Connection.ChangeDatabase("master");//在默认的数据库中执行创建数据库语句
                    try
                    {
                        Command.ExecuteNonQuery();//执行
                        System.Diagnostics.Process sqlProcess = new System.Diagnostics.Process();
                        sqlProcess.StartInfo.FileName = "osql.exe";
                        //sqlProcess.StartInfo.Arguments = " -U 数据库用户名 -P 密码 -d 数据库名 -i 存放sql文本的目录sql.sql";
                        sqlProcess.StartInfo.Arguments = $" -U {textEdit_uid.Text} -P {textEdit_pwd.Text} -d {textEdit_dbname.Text} -i {sqlPath}";
                        sqlProcess.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
                        sqlProcess.Start();//执行sql文件
                        Cursor.Current = Cursors.WaitCursor;//过程缓慢，让鼠标处理等待状态
                        sqlProcess.WaitForExit();
                        sqlProcess.Close();
                    }
                    finally
                    {
                        mySqlConnection.Close();
                        sqlConnection.Close();
                        Command.Connection.Close();
                        mySqlConnection.Dispose();
                        sqlConnection.Dispose();
                        Cursor.Current = Cursors.Default;//恢复鼠标的默认状态
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }