How to deploy and package my c# winform project that has a database

Question

0.00/5 (No votes)

See more:

Hi friends
i have an accounting software project that i design with c# winform,the project have about 50 form, they draw their information from my tables in my my database which i created with sql server.i am connecting to my database with this connectionstring("Data Source=Ese-PC;Initial Catalog=PIMS; User ID=sa;PWD=ese");
here is my problem i want to deploy/package this app to be installed in 10 computers which are connected over a local area network and has a server where my database will be i suppose.i have packaged ordinary winform before but have not deployed any winform that has a database involved, can someone help me out here
Thanks in advance

Posted 15-Nov-13 1:51am

Ese ochuko

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Ziee-M · Answer 1 · 2013-11-15T02:35:00

Solution 1

Hi Ese,

your app.config file will hold the information of your connection to the database(loacated in the server). so try to change your connection to get access to the database in the server.
Once done, deploy your application, there is no additional requirement as long as your target PC have access to the server.

Good luck.

Posted 15-Nov-13 2:35am

Ziee-M

Comments

Ese ochuko 16-Nov-13 5:55am

Hi tank u very much for your reply, you know have not done this before, so i have some more question,if i put the connection string in the app.config, dose that mean i have to remove the conection from all my forms,if so, how am i going to make my form use the conectionstring in the app.config. You said i should change my conectionstring to the server dose that mean that if i want to install this software in another place with a diferent server,i have to re_deploy again,please help me because i truely dont have any idear.thanks

Ziee-M 18-Nov-13 3:12am

Hi Ese, it seems you are using SqlConnection(i am not sure), in that case your connection string is set pragramatically, so you dont have to put it in the app.config.
For deploying in diffrent servers, you have to change the connection string and redeploy, since you connectionstring holds the server credantials and the server name...
i suggest you to start the deployment process, you will very soon notice that its not hard.
the first step is to change the connection string to access the server dataBase from your application(installed in a target PC).

Ese ochuko 26-Nov-13 2:42am

Thanks i will step on it immediately