怎样在打包程序中自动附加安装sql server数据库（How to install SQL automatic packing procedures in additional server database）.docVIP

怎样在打包程序中自动附加安装sql server数据库（How to install SQL automatic packing procedures in additional server database） 1, create the installation project Setup installation project On the file menu, point to add items, and then select new projects. In the add new Project dialog box, select installation and deployment projects in the project type pane, and then select Install items in the templates pane. In the name box, type setup (other names are OK, as per will). Click OK to close the dialog box. The project is added to the solution explorer, and the file system editor opens. In the properties window, select the ProductName property, and type in the XXXX system (the name of the project you are doing). 2, create the installer class (install.cs) in the installation project. Right on your projects solution, select the new project in add. Then select the class library, enter DbSetUp in the name, and select the directory where your project program is located. Click OK to close the dialog box. Right click on the new project, DbSetUp, and select new item in add. Then select the installer class in the Visual c# project item, and click Add to close the dialog box. Switch to the code view and write the following code in the install.cs file: Using System; Using System.Collections.Generic; Using System.ComponentModel; Using System.Configuration.Install; Using System.Diagnostics; Using System.Data.SqlClient; Namespace DBSetUp { [RunInstaller (true)] Public, partial, class, Installer1: Installer { Public, Installer1 () { InitializeComponent (); } Private, void, CreateDataBase () { / / start SQL service, installed after the service did not start prevention Process P = new, Process (); P.StartInfo.FileName = cmd.exe; P.StartInfo.UseShellExecute = false; P.StartInfo.RedirectStandardInput = true; P.StartInfo.RedirectStandardOutput = true; P.StartInfo.RedirectStandardError = true; P.StartInfo.CreateNoWindow = true; P.Start (); P.StandardInput.WriteLine (net start MSSQL$Rybx); //Rybx is the clie