Where to Store Database Connection

Posted Date: 09 Jun 2008	Resource Type: Code Snippets	Category: ADO.NET
Author: 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