Newbie question

[Guest]

WEB.CONFIG file is the best place to store connection
settings

In <appSettings> section, you may add some thing like
following sample
<add key="CONNSTR1" value="Data Source=DB1;User
ID=user1;Password=pass1;" />
<add key="CONNSTR2" value="Data Source=DB2;User
ID=user2;Password=pass2;" />

in the C# code, use to retrieve this info
string conStr = ConfigurationSettings.AppSettings
['CONNSTR1'];

Good luck
Sree