如何在VS2005中使用SqlServer部署(设置)VB.net? [英] How to deploy (Setup) VB.net with SqlServer in VS2005?

问题描述

专业人士...

我已经在VS2005中使用Sql Server Exp Ed在vb.net中完成了一个项目.现在完美了

运行时，我可以将数据检索或存储到数据库...

在我进行部署时，我浏览了诸如ClickOnce之类的网络上的一些文章，

安装程序e.t.c.，它为我提供了安装文件以及Sqlexpress之类的必备文件，

dotnetfx，winInstaller....

其实我的连接字符串是...

Hi Professionals...

I have done a project in vb.net with Sql Server Exp Ed in VS2005.. Now its perfectly

running, I can be able to retrieve or storing data to the database...

while i go for deployment part, as i go through the some articles on the web like ClickOnce,

Installer e.t.c., Its giving me Setup file along with Prerequisites files like Sqlexpress,

dotnetfx, winInstaller....

Actually My Connection string is...

 <add name="loyaltyCS" connectionstring="Data<br mode=" hold=" /><br mode=">
providerName="System.Data.SqlClient" /> </add>

它实际上运行得很好...

Microsoft建议我更改ConnectionString之类的..

Its actually running perfectly...

Microsoft suggested me to alter my ConnectionString like..

 <add name="loyaltyCS">

providerName="System.Data.SqlClient" connectionString="Data

Source=|DataDirectory|\dbloyalty.mdf;Integrated Security=True" /> 
</add>

但是此连接字符串无法正常工作....

我的问题..

1)如何分离我的Sql数据库

2)如何将数据库添加到我的项目中...

But this Connection string not working properly....

My Questions..

1) How to Detach my Sql Database

2) How to add the database into my project...

Its giving error of

 "An Error Occured While Processing the Local Data File \n<br />
OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT 

的给定错误
3)如何使用Sql Server Express Edition发布vb.net Windows应用程序...


我面临的问题:

1)如果我将我的项目安装文件安装到 C:\program files\APP\App.exe

加上第一个告诉的连接字符串，它只运行两次或三遍...

之后，显示错误类似

3) How to publish vb.net windows application with Sql Server Express Edition...


PROBLEMS I FACED:

1) If I installed my Project Setup file to the C:\program files\APP\App.exe

along with first told connection string, Its running only two or three times...

After that its displaying Error Like

 "The Application failed to initialize properly (0xc000007b). Clik on OK to terminate the

application" 

我是Visual Studio部署的新手，接下来的15天我必须将exe交给客户端...

请帮帮我...

提前谢谢...
Venkadesh

I''m new to the Visual Studio Deployment, Next 15 days i have to give the exe to the Client...

Please help me...

Thanks in advance...
Venkadesh

推荐答案

查看针对类似问题提出的答案创建设置并支持使用VS.NET创建数据库 [在安装.NET应用程序期间创建数据库 [部署您的应用程序和数据库 [

Look at the answers given for the similar question asked here[^].
Various article links are present in it that will help you achieve the same.

Have a look at these too:
Creating setup With support for database creation Using VS.NET[^]
Create database during installation of a .NET application [^]
Deploy your Application and Database[^]

这篇关于如何在VS2005中使用SqlServer部署(设置)VB.net?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！