How Do I Store and Access My Connection Strings in ASP.NET 2?
Yes, there is. ASP.NET 2.0 has a new ConnectionStringSettingsCollection called ConnectionStrings that provides easy access to your connection strings that you store in your Web.config file. All you need to do is add a <connectionStrings> element to your configuration file. To this element you can add your connection strings by adding <add> elements. You use the name attribute of the <add> element to specify the name by which you can retrieve the connection string in your code. You use the connectionString attribute to specify the connection string. Note that both attributes are case-sensitive. You should end up with the following <connectionStrings> element in your configuration file:
Persist Security Info=False;Initial Catalog=YourDatabase;
Once you have added the connection string to your configuration file, you can retrieve it with the following code:
At this point, MyConnectionString holds the connection string you defined in your configuration file.
The good thing about a separate <connectionStrings> element is that other config sections, like special Providers, can refer to those settings by the name of the connection string, instead of duplicating the connection string. You can retrieve more information about the connection besides the connection string. If you provide a providerName (as in the sample Web.config above) you can retrieve the providers's name in code as well. This can be useful if you're working with the new factory model in your data access layer and need to know with which data provider you're currently working.
Where to Next?
Wonder where to go next? You can post a comment on this article.
Links in this Document
|Written by||Imar Spaanjaars|
|Date Posted||02/19/2004 11:13|
|Date Last Updated||02/28/2006 19:16|
|Date Last Reviewed||12/06/2006 15:33|
Talk Back! Comment on Imar.Spaanjaars.Com
I am interested in what you have to say about this article. Feel free to post any comments, remarks or questions you may have about this article. The Talk Back feature is not meant for technical questions that are not directly related to this article. So, a post like "Hey, can you tell me how I can upload files to a MySQL database in PHP?" is likely to be removed. Also spam and unrealistic job offers will be deleted immediately.
When you post a comment, you have to provide your name and the comment. Your e-mail address is optional and you only need to provide it if you want me to contact you. It will not be displayed along with your comment. I got sick and tired of the comment spam I was receiving, so I have protected this page with a simple calculation exercise. This means that if you want to leave a comment, you'll need to complete the calculation before you hit the Post Comment button.
If you want to object to a comment made by another visitor, be sure to contact me and I'll look into it ASAP. Don't forget to mention the page link, or the Doc ID of the document.
Please correct the following errors:
Unfortunately, something went wrong and your message or comments have not been submitted successfully.
There's a fair chance things broke down because you tried to post something that looks like HTML. Things that look like HTML include (X)HTML, obviously, XML, ASP.NET markup and c# generics syntax as all of them use the < and > characters.
If that's the case, try altering your message and remove anything that looks like an angled bracket. You can replace them with [ and ] for example so you can still make it look like HTML to some extend.
If, on the other hand, you were trying to spam this web site, I am pretty glad I caught you in the act and stopped you from doing so ;-)
Also, please don't use links in your posts; I had to block them to filter out most of the junk mail I am receiving.