让安装程序在Sql Server数据库中建库、建表。
1、[项目]—[添加新项]
类别:代码;模板:安装程序类。
名称:MyInstaller.cs
2、在SQL Server建立一个表,再[所有任务]—[生成SQL脚本]。
生成类似如下脚本(注意:把所有GO语句去掉):
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MyTable] CREATE TABLE [dbo].[MyTable] (
[ID] [int] NOT NULL ,
[NAME] [nchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[MyTable] WITH NOCHECK ADD
CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
3、[项目]—[添加现有项]。mytable.sql—[生成操作]-[嵌入的资源]。
4、将MyInstaller.cs切换到代码视图,添加下列代码:
先增加:
using System.Reflection;
using System.IO;
然后:
private string GetSql(string Name)
{
try
{
Assembly Asm = Assembly.GetExecutingAssembly();
Stream strm = Asm.GetManifestResourceStream(Asm.GetName().Name + "." + Name);
StreamReader reader = new StreamReader(strm);
return reader.ReadToEnd();
}
catch (Exception ex)
{
Console.Write("In GetSql:"+ex.Message);
throw ex;
}
} private void ExecuteSql(string DataBaseName,string Sql)
{
System.Data.SqlClient.SqlConnection sqlConn = new System.Data.SqlClient.SqlConnection();
sqlConn.ConnectionString = "server=myserver;uid=sa;password=;database=master";
System.Data.SqlClient.SqlCommand Command = new System.Data.SqlClient.SqlCommand(Sql,sqlConn); Command.Connection.Open();
Command.Connection.ChangeDatabase(DataBaseName);
try
{
Command.ExecuteNonQuery();
}
finally
{
Command.Connection.Close();
}
}
protected void AddDBTable(string strDBName)
{
try
{
ExecuteSql("master","create DATABASE "+ strDBName);
ExecuteSql(strDBName,GetSql("mytable.sql"));
}
catch(Exception ex)
{
Console.Write("In exception handler :"+ex.Message);
}
} public override void Install(System.Collections.IDictionary stateSaver)
{
base.Install(stateSaver);
AddDBTable("MyDB"); //建一个名为MyDB的DataBase
}
5、[添加新项目]—[项目类型:安装和部署项目]—[模板:安装项目]—[名称:MySetup]。
6、[应用程序文件夹]—[添加]—[项目输出]—[主输出]。
7、解决方案资源管理器—右键—[安装项目(MySetup)]—[视图]—[自定义操作]。[安装]—[添加自定义操作]—[双击:应用程序文件夹]的[主输出来自***(活动)]。
1、[项目]—[添加新项]
类别:代码;模板:安装程序类。
名称:MyInstaller.cs
2、在SQL Server建立一个表,再[所有任务]—[生成SQL脚本]。
生成类似如下脚本(注意:把所有GO语句去掉):
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MyTable] CREATE TABLE [dbo].[MyTable] (
[ID] [int] NOT NULL ,
[NAME] [nchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[MyTable] WITH NOCHECK ADD
CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
3、[项目]—[添加现有项]。mytable.sql—[生成操作]-[嵌入的资源]。
4、将MyInstaller.cs切换到代码视图,添加下列代码:
先增加:
using System.Reflection;
using System.IO;
然后:
private string GetSql(string Name)
{
try
{
Assembly Asm = Assembly.GetExecutingAssembly();
Stream strm = Asm.GetManifestResourceStream(Asm.GetName().Name + "." + Name);
StreamReader reader = new StreamReader(strm);
return reader.ReadToEnd();
}
catch (Exception ex)
{
Console.Write("In GetSql:"+ex.Message);
throw ex;
}
} private void ExecuteSql(string DataBaseName,string Sql)
{
System.Data.SqlClient.SqlConnection sqlConn = new System.Data.SqlClient.SqlConnection();
sqlConn.ConnectionString = "server=myserver;uid=sa;password=;database=master";
System.Data.SqlClient.SqlCommand Command = new System.Data.SqlClient.SqlCommand(Sql,sqlConn); Command.Connection.Open();
Command.Connection.ChangeDatabase(DataBaseName);
try
{
Command.ExecuteNonQuery();
}
finally
{
Command.Connection.Close();
}
}
protected void AddDBTable(string strDBName)
{
try
{
ExecuteSql("master","create DATABASE "+ strDBName);
ExecuteSql(strDBName,GetSql("mytable.sql"));
}
catch(Exception ex)
{
Console.Write("In exception handler :"+ex.Message);
}
} public override void Install(System.Collections.IDictionary stateSaver)
{
base.Install(stateSaver);
AddDBTable("MyDB"); //建一个名为MyDB的DataBase
}
5、[添加新项目]—[项目类型:安装和部署项目]—[模板:安装项目]—[名称:MySetup]。
6、[应用程序文件夹]—[添加]—[项目输出]—[主输出]。
7、解决方案资源管理器—右键—[安装项目(MySetup)]—[视图]—[自定义操作]。[安装]—[添加自定义操作]—[双击:应用程序文件夹]的[主输出来自***(活动)]。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货