The scenario: a site which uses Flash for the front end, and Flash remoting for handling database calls between Flash and the server. There are also some admin aspx pages for maintaining the database. The connection string is stored in web.config, which allows me to call it from various aspx pages like this:
All the remoting calls are stored in a dll.

Question: is there a way to access the connection string in web.config from the dll? Adding a 'using System.Configuration' statement to the dll doesn't work. I've hard-coded the connection string inside the dll, but it would be nice if it only had to be specified in web.config. :)

Rob

Its kinda late here so im not thinking very cleary, so I am not sure if this will point you in the right direction but, in DLL's when i want to reference say, a physical path on the server with Server.MapPath() I have to do HTTPContext.Current.Server.MapPath() Look into that class and see if it has the functionality for pulling the connection strings.

post back if not and Ill take a look at it tomorrow when i have had some well earned sleep ^^

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Doug,

I've looked into HTTPContext.Current.Server.MapPath(), and I'm not sure if this is the solution. One problem is that I get a compile error when I build the dll:

"The type or namespace name 'HttpContext' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)"

Adding a "using System.Web" line doesn't help. That's part I can't figure out: how do you get a .dll to know it's being used in a web application

After wading through a mountain of inaccurate solutions on various web sites (have you noticed how common that is?), I finally figured it out.

If you are using VS 2005, ASP.NET 2.0 with C# and you want to retrieve a connection string from web.config, you can use ConfigurationManager:
However, you have to do two things first:

1. Add "using System.Configuration;" to the class file.

2. In Solution Explorer, right-click on the References folder and select "Add Reference". From the Add Reference dialog, select the ".NET" tab and select "System.Configuration" from the Component Name list.