About the value of appSettings in the Web.config file

As an example this minimal web.config with an appSetting entry to hold our connection string:

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<system.web>

<compilation defaultLanguage="c#" debug="true" />

</system.web>

<appSettings>

<add key="ConnectionInfo" value="server=(local);database=Northwind;Integrated Security=SSPI" />

</appSettings>

</configuration>

To read the key you use the ConfigurationSettings class from the System.Configuration namespace:

private void Page_Load(object sender, EventArgs e)

{

string connectionInfo = ConfigurationSettings.AppSettings["ConnectionInfo"];
using(SqlConnection connection = new SqlConnection(connectionInfo))

{

connection.Open();

// perform work with connection

}

}

You can refer server address by your computer name also! Got it ?

Peca55 at 2007-8-30 >