如何使用sql server数据库制作带有数据库，visual studio，桌面应用程序的.exe文件。 [英] How to make .exe file with database, visual studio, desktop app with sql server database.

问题描述

我刚刚在visual studio 2012/2015中完成了一个名为Restaurant Management System的桌面应用程序的设计和编码。我使用sql server management studio 2014作为数据库。现在我可以在没有
数据库的installshield的帮助下轻松创建.exe文件。我必须使用这个.exe文件在客户端机器上安装sql server但是它很荒谬。所以请这里的任何人都可以帮我设置数据库的文件。感谢您的帮助。

解决方案

您好，

感谢您在此发帖。

根据您的描述，您是否要在客户端上安装SQL？ 如果是，您可以参考该文档。

https ：//docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation

https://www.codeproject.com/Articles/305113/How-to-Install-SQL -server-2008-on-Windows-7

当您开发餐厅管理系统应用程序时，遇到一些问题，请随时与我联系。

最好的问候，

Hart

编辑：

如果你想要使用数据库制作安装文件， 你可以使用
ClickOnce    或 传统Windows安装程序

传统的Windows Installer技术用于标准的安装和部署项目以及ClickOnce部署。部署SQL Server Compact数据库时，ClickOnce部署提供了一个选项，如果在目标计算机上未检测到，则会自动安装SQL Server Compact
。

I have just finished designing and coding A desktop app Named as Restaurant Management System in visual studio 2012/2015. iam using sql server management studio 2014 as a database. Now i can easily create .exe file with the help of installshield without database. I have to install sql server on client machine with this .exe file but its ridiculous.so that please anyone here can help me to make setup  file with database. Thanks for ur Help.

解决方案

Hi,

Thank you for posting here.

According to your description, Did you want to install SQL on client?  If yes, you can reference the document.

https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation

https://www.codeproject.com/Articles/305113/How-to-Install-SQL-server-2008-on-Windows-7

When you develop restaurant management system app, you encounter some issue, please feel free to contact me.

Best Regards,

Hart

Edit:

If you want to make setup file with database,  you could use the ClickOnce   or Traditional Windows Installer

Traditional Windows Installer technology is used in both standard Setup and Deployment projects and in ClickOnce deployment. When you deploy a SQL Server Compact database, ClickOnce deployment provides an option that automatically installs SQL Server Compact if it is not detected on the target computer.

这篇关于如何使用sql server数据库制作带有数据库，visual studio，桌面应用程序的.exe文件。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！