Wednesday, February 21, 2007

Fetching Connctionstring From Web.config for DBClass

One of the Best Practise in website is Keeping Your Connection string in Web.config

1.Adding Connection string in Web.config

""appSettings""
""add key ="dbstring" value ="Connectionstring""
""appSettings ""

2.Adding the above connection string to Your DB Class

Imports System.Configuration

Imports System.Data.SqlClient

Public dbcon As New SqlConnection
dbcon.ConnectionString = ConfigurationManager.AppSettings("dbstring")

No comments: