VS2005 Web应用程序打包并安装数据库

 1 using System.ComponentModel;
 2 using System.Configuration.Install;
 3 using System.Collections; //以下引入
 4 using System.Collections.Specialized;
 5 using System.Data;
 6 using System.Data.SqlClient;
 7 using System.Reflection;
 8 using System.Xml;
 9 
10 namespace DbClass
11 {
12     [RunInstaller(true)]
13     public partial class InstallDB : Installer
14     {
15         /// <summary>
16         /// 必需的设计器变量,均来自于安装程序的“自定义操作”视图中的设置
17         /// </summary>
18         private string hostname;
19         private string username;
20         private string userpassword;
21         private string dbname;
22 
23         public InstallDB()
24         {
25             InitializeComponent();
26         }
27 
28         private string CreateSqlStr()
29         {
30             string sqlstr = "";
31             string datafile = Context.Parameters["installdir"] + @"FlowerShop.mdf";
32             string logfile = Context.Parameters["installdir"] + @"FlowerShop_log.ldf";
33             sqlstr = "EXEC  sp_attach_db @dbname =‘" + Context.Parameters["dbname"] + "‘,@filename1=‘" + datafile + "‘,@filename2=‘" + logfile + "‘";
34             return sqlstr;
35         }
36 
37         private void ExecuteSql(string DatabaseName, string SqlStr)
38         {
39             string SqlConnectionStr = @"server=" + hostname + ";uid=" + username + ";pwd=" + userpassword;
40             SqlConnection myConnection = new SqlConnection(SqlConnectionStr);
41             SqlCommand myCommand = new SqlCommand(SqlStr, myConnection);
42             myCommand.Connection.Open();
43             myCommand.Connection.ChangeDatabase(DatabaseName);
44             myCommand.ExecuteNonQuery();
45             myCommand.Connection.Close();
46         }
47 
48         private void AddFlowerShopDataBase()
49         {
50             ExecuteSql("pubs", CreateSqlStr()); 
51         }
52 
53         private void ModifyXML()
54         {
55             string XMLdir = Context.Parameters["installdir"] + @"Web.config";
56             XmlNodeReader reader = null;
57             XmlTextWriter writer = null;
58             XmlDocument doc = new XmlDocument();
59             doc.Load(XMLdir);
60             reader = new XmlNodeReader(doc);
61             writer = new XmlTextWriter(XMLdir, System.Text.Encoding.UTF8);
62 
63             try
64             {
65                 while (reader.Read())
66                 {
67                     if (reader.NodeType == XmlNodeType.Element && reader.Name == "connectionStrings")
68                     {
69                         string strContent = reader.ReadInnerXml();
70                         strContent = "<add name=\"strShop\" connectionString=\"server=" + hostname + ";database=" + dbname + ";uid=" + username + ";pwd=" + userpassword + "\" providerName=\"System.Data.SqlClient\"/>";
71                         XmlNode root = doc.DocumentElement;
72                         XmlElement elem = doc.CreateElement("connectionStrings");
73                         elem.InnerXml = strContent;
74                         root.ReplaceChild(elem, root.ChildNodes[1]);
75                         doc.Save(writer);
76                         break;
77                     }
78                 }
79             }
80             finally
81             {
82                 if (reader != null)
83                     reader.Close();
84             }
85         }
86 
87         public override void Install(IDictionary stateSaver)
88         {
89             base.Install(stateSaver);
90             hostname = Context.Parameters["hostname"];
91             username = Context.Parameters["username"];
92             userpassword = Context.Parameters["userpassword"];
93             dbname = Context.Parameters["dbname"];
94             this.AddFlowerShopDataBase();
95             this.ModifyXML();
96         }
97     }  
98 }