how to use the connection string written in web.config file within .net application 2.0

18y

6.4k

You write connection string in the web.Config file. Like

connectionStrings>

In program you can use like this

Dim cnn As SqlConnection

cnn = New SqlConnection()

cnn.ConnectionString = ConfigurationManager.ConnectionStrings("nwindCnn").ConnectionString

You can write any number connection strings by giving proper names.

18y