I am currently developing a destop application which retrieves data from web service.

I have both projects in my solution.

I have a web.config in the Web Service project which details a connection string. I also have an app.config in the other project which also details a connection string.

When I try to access the connection string from the Web Service project using the ConfigurationManager class my project picks up the connection string from the app.config.

Why is this happening and how do I set it so it picks up from the web.config in the same project?

(A portion from app.config in my desktop project)
<connectionStrings>
<add name="DSWCLink.My.MySettings.DSWCConnectionString" connectionString="Data Source=2003SQL;Initial Catalog=databasename;Persist Security Info=True;User ID=sa"
providerName="System.Data.SqlClient" />
</connectionStrings>




(A Portion from my web.config in my Web Service project)

<connectionStrings>

<add name="DSWCConnectionString"
connectionString="Data Source=2003SQL;Initial Catalog=DBLink;Persist Security Info=True;User ID=sa"
providerName="System.Data.SqlClient" />
</connectionStrings>


(The code in my web service project)
Dim strConnectionString As String = ConfigurationManager.ConnectionStrings(0).Connecti onString

Dim sqlConn As New SqlConnection(strConnectionString)

(The strConnectionString picks up the value from app.config in a different project. The desktop app)

Hope this makes sense.

You can choose the string by name instead of index.

Dim strConnectionString As String = ConfigurationManager.ConnectionStrings("DSWCConnec tionString").Connecti onString

__________________
Visit my blog at http://leedumond.com
Follow me on Twitter: http://twitter.com/LeeDumond

I used the index for quickness. If I specify the name I get the following error:

"GetData Object reference not set to an instance of an object."

This is based on the following line of code:

Dim strConnectionString As String = ConfigurationManager.ConnectionStrings("DSWCConnec tionString").ConnectionString

The reason for this is that the ("DSWCConnectionString") exists in web.config but not app.config (which is correct as the web service is only added to the desktop project for debugging)

If I specify 0 it picks up the connection string from app.config.

More Info. (Just incase I am not making myself clear)

I am developing a desktop app that sends and receives data to a web service which I am also developing.

I have one solution which includes the Web Service project and the Desktop project. I have added a reference to the web service project to my desktop project.

The code I am having trouble with is the GetData function in the Web Service Project. (This is where I use the ConfirgurationManager.Conn... code)

Instead of picking up from Web.Config in that project, the connection string returned is from the App.Config file in my desktop project.

Hope this is more clear.

Hmmm... I see.

Have you tried WebConfigurationManager instead of ConfigurationManager? Mostly the same API. As I understand it, main difference is that WebConfigurationManager looks in web.config files only.

__________________
Visit my blog at http://leedumond.com
Follow me on Twitter: http://twitter.com/LeeDumond

I have tried using the following code:

Dim strConnectionString As String = System.Web.Configuration.WebConfigurationManager.C onnectionStrings("DSWCConnectionString").Connectio nString


But still get the error:

"GetData Object reference not set to an instance of an object."

Also when using the WebConfigurationManager code and specifying an index of 1 instead of the name returns the connection string from app.config.