Click here to Skip to main content
15,885,214 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

I have one windows applications which is having some set of windows forms and also I am maintaining sql database with these application for storing and updating the data from the windows forms. This is working fine in my local system. Problem is I want to setup the project and install my project in other machine but how can I handle setup and deployment of my windows application with sql database. bcz I used connection string of the local system like 'datasource = lenovo/.......'.

Please suggest.


Raju G
Posted

1 solution

you have to detach and attach the data base and have to use the connection string like

SqlConnection con = new SqlConnection("server=.\\SQLEXPRESS;database=name_of_database;trusted_connection=true;");

It will work fine when you deploy your app in different system..
 
Share this answer
 
Comments
rajugknr 9-Jul-13 1:10am    
Thank you I will try this.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900