Publish c# application in visual studio 2010 with sql server 2008?

Question

Hello My Dear Friends, i want to ask how can i publish c# application in visual studio 2010 to executable program with sql server 2008? Thanks in advance. ??

Arnab Mukherjee · Answer

Hi, Using Visual Studio you can create a setup project and install prerequisites that you need during installation.The installation process is very simple and the end user can install application and prerequisites after clicking next buttons. Here are the steps for Creating a Setup Project: Create a Setup Project Add new project → setup and deployment → setup project Right Click on Setup project and Add project Output and select primary output from your main project Right Click on Setup project and Add project Output and select content files from your main project Right Click on setup project and Click Properties and click Prerequisites and select SQL Server Express Select .Net Framework Select Windows Installer Select radio button Download prerequisites from the same location as my application. Right Click on Users Desktop at left pane and add new Shortcut and select application folder, primary output from SampleApplication, and click ok and the rename the short cut to what you need. Rebuild solution. Rebuild Setup Project Go to Output directory of setup project and run setup.exe It's that easy. 1. https://www.c-sharpcorner.com/UploadFile/996353/create-setup-and-deployment-project-in-visual-studio-200820/ 2. https://stackoverflow.com/questions/32956142/how-to-deploy-application-with-sql-server-database-on-clients

Arnab Mukherjee · Answer

You can use the connection string as follows and you only need to add your database name. string connetion = "Data Source=.;Initial Catalog=DB name;Integrated Security=True;MultipleActiveResultSets=True";

Ahmet Taha · Answer

It cannnot work for my project because my system has an external database in sql server 2008 .im not using internal database. The main problem is connection string as i mentioned my database is external. And my project would be run to other computer without chnaging the connection string? Thanks in advance

Arnab Mukherjee · Answer

Hi, If you’d like to install the SQL Server in computers by using Setup Project, the most important step is to select the SQL Server 2008 related options in Prerequisites from right-clicking Setup Project > Properties > Configuration Properties > Build > Prerequisites. Also, choose some necessary prerequisites to install and specify the install location for prerequisites. Please go through the link given below. https://www.youtube.com/watch?v=1PWnehfCh2U

Ahmet Taha · Answer

Is that the same because my database is external in sql server 2008?