how to assign server name of client machine during installing setup

Question

0.00/5 (No votes)

See more:

Hello Every one

I have a problem that i built a project in windows form c#
which is dealing with stroing and retriving of data in sql server 2008 database
but , for building process i coded the server name of my machine now i have to install it in client machine how can i change this server name with client server name other wise it will shows a server not found error.
I need more suggestions

Thank you .

Posted 14-Oct-13 23:56pm

A.Girish

Add a Solution

4 solutions

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)

Amol_B · Answer 1 · 2013-10-17T23:41:00

Solution 3

You should not hard code server name and connection string.Store them in app.config instead.So that at l tare date, if you want to change connection string you only have to make change in app.config and not in your code.
add section like below in you app.config

XML

<appSettings>
  
   <add key="ConnectionString" value="actual connection string" />
  
 </appSettings>

use below code to read value from app settings.

System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]

Posted 17-Oct-13 23:41pm

Amol_B

Comments

A.Girish 21-Oct-13 0:14am

How can i change the connection string manually once i created the Setup File...

Amol_B 21-Oct-13 8:15am

Once you install your setup file, it will extract application in C:\Program Files (or other location if you chosen) Go to that location edit app.config file and save it. this way you can change connection string. Note that name of app.config file will be application.config(if your application name is abc.exe then config file will be abc.config

A.Girish 22-Oct-13 0:19am

Thnks dude..

Dipesh Wadhwa · Answer 2 · 2013-10-18T01:28:00

Solution 4

Use app.config file and change the connection string manuaaly, app.config file does not require to re-compile.
Or
Use following SqlConnection

C#

SqlConnection MyConnection=new SqlConnection("Server=(Local); Database=DatabaseName; Integrated Security=True");

Posted 18-Oct-13 1:28am

Dipesh Wadhwa

Updated 18-Oct-13 1:30am

v3

Madhu Nair · Answer 3 · 2013-10-15T00:24:00

It is not a good idea to store the server name in code. You should always specify connection strings in your app.config file. This will enable you to change the connection string without making any changes to the code. You can change the connection string with your production server details at the time of building your setup or after the installation is complete.

A.Girish · Answer 4 · 2013-10-15T18:04:00

Solution 2

can u post any article or process by simple example

Thank you

Posted 15-Oct-13 18:04pm