Hi,

(1) What's the best place to store connection string in a ASP.Net project?
(2) How can I access it in asp pages?
(3) What's the solution for global variables in a ASP.Net project?

Thanx.

__________________
nalaka hewage
http://nalakahewage.blogspot.com

1. Most recommend you put the connection string in the web.config file:

<appSettings file="user.config">
  <add key="CONNSTRING" value="<your connection string here>" />
</appSettings>

2. Retrieve it using System.Configuration.ConfigurationSettings:
C#: System.Configuration.ConfigurationSettings.AppSett ings["CONNSTRING"]
VB: System.Configuration.ConfigurationSettings.AppSett ings("CONNSTRING")

3. Avoid using them. A properly designed application shouldn't need them. What would you intend to use them for? There may be better solutions depending on what you want to do.

-Peter

Hi peter,

Thank you very much.


nalaka hewage