C# Discussion Boards - CodeProject

6-Sep-09 23:55

Hi All

I am adding app.config file in application folder of setup project for creating installer.
after installing application when we run it ..if gives following error

The Key ConnectionString does not exist in the app setting configuration section

but when I run application in Dotnet.it runs fine but when run after installing then there is above error occurs

here is app.config file

<configuration>
  <appSettings>
    <add key="ConnectionString" value="data source=localhost\sqlexpress;initial catalog=SFM;integrated security=SSPI;persist security info=False;packet size=4096" />
  </appSettings>
</configuration>

Thankz in Advance
Regards
Kashif
Rose | [Rose]

modified on Monday, September 7, 2009 6:05 AM

Keith Barrow7-Sep-09 0:02

7-Sep-09 0:02

Unless I misunderstand the error is correct:

The Key <big>ConnectionString</big> does not exist in the app setting configuration section

as in

<add key="<big>Main.ConnectionString</big>" value="...

the key is "Main.ConnectionString"

Hope this give you the answer you need!

xodeblack7-Sep-09 0:09

7-Sep-09 0:09

First of all thankz for your reply
Sorry keefb
it is my written mistake in question .......In project I am using same key .........now I corrected my question ...please check it again ......In app.config the key is ConnectionString .........and I also use ConnectionString (Same variable) in Code file ............Now please check it and can you tell me where is problem ....
why error occurs that I mentioned in first post

Blush | :O

Keith Barrow7-Sep-09 0:14

7-Sep-09 0:14

Can you post the code that gets the connection string?

xodeblack7-Sep-09 0:23

7-Sep-09 0:23

Here is code

public clsGeneric()//Constructor
        {            
            _mainConnection = new SqlConnection();
            AppSettingsReader _configReader = new AppSettingsReader();

            _mainConnection.ConnectionString = _configReader.GetValue("ConnectionString ", typeof(string)).ToString();

        }

When I run project from visual studion it run fine......but when I create installer and install application then run from installed exe then error occurs

Keith Barrow7-Sep-09 0:26

7-Sep-09 0:26

Is there an app.config or yourapplicationname.exe.config in the installation folder?

xodeblack7-Sep-09 0:29

7-Sep-09 0:29

app.Config.

I added this file in application folder of setup project

Keith Barrow7-Sep-09 0:56

7-Sep-09 0:56

There is the problem. Say your application builds to an exe called Foo.exe, it expects the app config file to be named Foo.exe.config, not app.config. So you can't just copy the app.config into the installer directly.

Make sure the Installer project has "Primary output from your project name here (Active)" in it. As long as the app.config exists in the source project it should be installed with the correct name.

Also Greg Chelstowski's post is correct, you should consider using a ConnectionString element in your app.config rather than adding the connection string as an app setting.

xodeblack7-Sep-09 1:04

7-Sep-09 1:04

Hi keefb
very Thankz

Problem is fix

Greg Chelstowski7-Sep-09 0:30

Greg Chelstowski

7-Sep-09 0:30

Why do you not use ConfigurationManager.AppSettings["ConnectionString"].Value.ToString() instead?

Moreover, why do you store your connection string as an appsetting, and not as connectionString in your app.config?

var question = (_2b || !(_2b));

xodeblack7-Sep-09 1:05

How do i set a date using Crystal Reports

7-Sep-09 1:05

Thankz Greg Chelstowski

I change the connection string according to ur post

rehpot6-Sep-09 23:15

rehpot

6-Sep-09 23:15

I am currently designing a quotation and would like to add a Valid Till date to show how long the quote is valid. For instance, if the quote was generated today, i would like the "valid till" date to be set from today plus 30 days. How would i do this in crystal syntax?

how to get ip of remote machine in a LAN

Ajithevn6-Sep-09 23:10

Ajithevn

6-Sep-09 23:10

if i have a c# application.exe installed in a remote system can i get the ip of that system
if yes plz help me

Re: how to get ip of remote machine in a LAN [modified]

Harvey Saayman6-Sep-09 23:15

Harvey Saayman

6-Sep-09 23:15

System.Net.IPAddress[] myIpAddresses = System.Net.Dns.GetHostAddresses(Environment.MachineName);

<Edit> oops, only just saw you wanted remote machine. In that case just specify the HostName instead of Environment.MachineName like so...

System.Net.IPAddress[] myIpAddresses = System.Net.Dns.GetHostAddresses("SomeComputer");

</Edit>

<Edit2> OMG, i think I'm experiencing dyslexia!!

If you want to run the app remotely and get its machines IP use the 1st snippet, but like CG said it needs to be sent somewhere...

If you have the remote machines HostName you can use the 2nd snippet on the local machine.
</Edit2>

Harvey Saayman - South Africa
Software Developer
.Net, C#, SQL
you.suck = (you.Occupation == jobTitles.Programmer && you.Passion != Programming)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

modified on Monday, September 7, 2009 5:22 AM

Ajithevn7-Sep-09 4:08

Ajithevn

7-Sep-09 4:08

i need to find out all the machines running the application.exe how is that possible

Harvey Saayman7-Sep-09 4:10

Harvey Saayman

7-Sep-09 4:10

Have application.exe get the IP address, and write it into a SQL database. That would be the easiest way to do it...

Ajithevn7-Sep-09 4:18

Ajithevn

7-Sep-09 4:18

is it possible to use dataset in place of sql database, but i dont know how to transfer data from one machine to another using datasets.can u help me