C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Bunty (130)
Murali (122)
SweetGhost (96)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Where to Store Database Connection

Posted Date: 09 Jun 2008 Resource Type: Code Snippets Category: ADO.NET

Posted By: Kumar Velu Member Level: Diamond
Rating:

Points: 10

The following code sample shows How to Store Database Connection.
In Web.Config, you would add a key to the AppSettings Section:


 



for OleDb - use Absolute Path - Not Server.MapPath:

Then, in your ASP.Net application - just refer to it like this:

 
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings("MyDBConnection"));

Responses

Author: Kapil Dhawan 16 Jun 2008 Member Level: Gold Points : 1

Hello,
Nice piece of Code.
Thanks for sharing your knowledge with us.

You must provide proper code.

Regards,
Kapil

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to pass value from one form to another form
	Previous Resource: How To Get Connection String
	Return to Discussion Resource Index
	Post New Resource
	Category: ADO.NET

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

silicone halloween mask