Connection String formats

My connection string from Web Config. Check out www.connectionstrings.com for some good samples!

·   This conn string is used when the DB is on the local HD somewhere.

       <connectionStrings>

        <add name="D:\C#-206\VS 2005\HALLOWEEN.MDFConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=’D:\C#-206\VS 2005\HALLOWEEN.MDF’;Integrated Security=True"

      providerName="System.Data.SqlClient" />

 </connectionStrings>

·   Use this conn string when the DB is inside the app_data folder inside your app folder.

<connectionStrings>

        <add name="HalloweenConnection"

          connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Halloween.mdf;Integrated Security=True"

          providerName="System.Data.SqlClient"/>

    </connectionStrings>