怎样在打包程序中自动附加安装sql server数据库(How do you.doc

怎样在打包程序中自动附加安装sql server数据库(How do you
automatically install an additional SQL Server database in
your packaged prograe instance name
. WriteLine ("exit");
(p. StandardOutput. ReadToEnd);
/ / "server": the client database instance name "user ID": Sa, password: Sa password
String strSql = string. Format ("server二{0} user: id={l}: password={2}: Database=master" @ "(local) \Rybx", "Sa", qjs )；
/ / additional database files, I set in the process of the project under the installation directory under the database folder
String strMdf this. Context. Parameters[二"targetdir"] + @ \database'RybxMis. mdf";
String strLdf . Parameters[二"targetdir"] + @ \database'RybxMis. ldf";
String str;
SqlConnection myConn = new SqlConnection (strSql);
str = "exec sp _ attach _ db @ dbname = he rybxmis, @ f ilenamel = n ' + strmdf +", @ filename2 = n' + strldf + ;
sqlcommand mycommand = new sqlcommand (str, myconn);
myconn. open ();
mycommand. executenonquery ();
myconn. close ();
protected override void onafterinstall
(system. collections. idictionary savedstate) base, onafterinstall (savedstate);
try createdatabase ();
catch (exception ex) throw new exception ( ()); 单击〃生成〃菜单下〃生成解决方案〃，生成install, dl 1安装类文 件.
3、 将〃主程序〃项目的输出添加到部署项目中
在你项目程序的安装项目（上面第一步创建的setup）上右键，选择 〃视图〃中的〃文件系统〃，在〃应用程序文件夹〃上右键，选择〃 添加〃中的〃项目输出〃，打开〃添加项目输出组〃对话框，在〃项 目〃下拉表框中选择你的主安装程序类，如上面