ConnectionString Retrieval in file other than Web.config RSS

• • Reply
  

  TinyPond

  Member

  739 Points

  228 Posts

  ConnectionString Retrieval in file other than Web.config

  Nov 18, 2010 03:31 PM|LINK

  I have an EnvironmentsConfig folder in it I have a file connectionstrings.config

  It has a connection string that I need to retrieve. I understand how to do this using the web.config but I can't seem to find the correct C# code for pulling it from this new folder and file.

   

  Here is the xml in the connectionstring.config file

  <xml version="1.0"?>
  <connectionStrings>
  <add name="DBConnection" connectionString="Data Source=xxx,111;Initial Catalog=somedb;User ID=someuser;Password=somepassword;" />
  </connectionStrings>

  Normally I would use the following code to get the connection string

  ConfigurationManager.ConnectionStrings["YourConnName"].ConnectionString;

  
   

  can someone please show me the correct syntax?

  TinyPond
  • Moved by mbanavige on Nov 18, 2010 03:43 PM
• • Reply
  

  TinyPond

  Member

  739 Points

  228 Posts

  Re: ConnectionString Retrieval in file other than Web.config

  Nov 18, 2010 04:06 PM|LINK

  Added the following to my WebConfig file. This allows me to pull the connection information from the connectionstring.config file through the web.config and everything works as it should.

   

  <connectionStrings configSource="EnvironmentConfigs\connectionstrings.config">
    </connectionStrings>

  
   

  TinyPond
  • Marked as answer by TinyPond on Nov 18, 2010 04:06 PM
• • Reply
  

  krunal_it17

  Member

  59 Points

  50 Posts

  Re: ConnectionString Retrieval in file other than Web.config

  Jan 07, 2013 09:21 AM|LINK

  Hi

  i need to write my connection string dynamically in that

  "connectionstrings.config" file so how can I do this.
  
  
  Thankx,