How do I read cnnection string from web config file

[Tomic]

I had the following code: Dim constr as string Dim mysystem as system.configuration.configuration mysystem=system.web.configuration.webconfigurationmanager.openwebconfigura tion(Nothing) Dim mycon as System.Configuration.ConnectionSettings mycon=mysystem.connectionstrings.connectionstrings("CString1") constr =mycon.connectionstringhe code above returned the error below: "Object not sent to an instance of an object" on the line constr =mycon.connectionstring Please where did I get it wrong. Thanks

[pmarfleet]

To read a connection string from web.config using WebConfigurationManager, all you need to do is:

Dim constr As String = WebConfigurationManager.ConnectionStrings("CString1")

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Sunil Wise]

in web.config: <appSettings> <add key="ConnString" value="server=(local);database=Northwind;Integrated Security=SSPI" /> </appSettings> call in u r web page as Imports System.Web.Configuration dim constr as string constr=ConfigurationManager.ConnectionStrings("ConnString").ConnectionString use this hope this helps