using System.Configuration; //include System.Configuration namespace

//To read a connection string
string ConnectionString = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;

//To read the provider name
string ProviderName = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ProviderName;




>All,
>
> How do I read the connection string? The settings I am using is below.
>

><configuration>
>   <appSettings/>
>
>      <connectionStrings>
>
><add name="WebShopper" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=WebShopper;Integrated Security=True" providerName="System.Data.SqlClient"/>
>
><remove name="LocalSqlServer"/>
>
><add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;initial catalog=WebSite;integrated security=SSPI;persist security info=False;workstation id=WTI01;packet size=4096" providerName="System.Data.SqlClient"/>
>
></connectionStrings>
>

>Thanks
>
>Jim