What's Here?
- Members: 300,308
- Replies: 825,515
- Topics: 137,361
- Snippets: 4,417
- Tutorials: 1,147
- Total Online: 2,080
- Members: 128
- Guests: 1,952
|
This is a snippet I use to retrieve my database connection string I store in the web.config file.
|
Submitted By: PsychoCoder
|
|
Rating:
|
|
Views: 41,267 |
Language: C#
|
|
Last Modified: January 20, 2008 |
Instructions: Pass the method and it will return the connection string for that name (works well if you have multiple connections in the config file) and it will retrieve that specific connection string.
If you fail to provide the name of a connection string it will default to your default (usually 1st in the list) to the default string. |
Snippet
#region GetConnectionstring /// <summary> /// method to retrieve connection stringed in the web.config file /// </summary> /// <param name="str">Name of the connection</param> /// <remarks>Need a reference to the System.Configuration Namespace</remarks> /// <returns></returns> public string GetConnectionString(string str) { //variable to hold our return value string conn = string.Empty; //check if a value was provided if (!string.IsNullOrEmpty(str)) { //name provided so search for that connection conn = ConfigurationManager.ConnectionStrings[str].ConnectionString; } else //name not provided, get the 'default' connection { conn = ConfigurationManager.ConnectionStrings["YourConnName"].ConnectionString; } //return the value return conn; } #endregion
Copy & Paste
|
|
|
|
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
| 
