<div>
Why not have different keys but have different names? &nbsp;<br />
<br />
&lt;add name=&quot;myGG1&quot; connectionString=&quot;Data Source=myDataBase;Initial Catalog=myGG;Integrated Security=True&quot; providerName=&quot;System.Data.<wbr />SqlClient&quot;<wbr /> /&gt;<br />
&lt;add name=&quot;myGG2&quot; connectionString=&quot;Data Source=myDataBase;Initial Catalog=myGG;Integrated Security=True&quot; providerName=&quot;System.Data.<wbr />SqlClient&quot;<wbr /> /&gt;<br />
&lt;add name=&quot;myGG3&quot; connectionString=&quot;Data Source=myDataBase;Initial Catalog=myGG;Integrated Security=True&quot; providerName=&quot;System.Data.<wbr />SqlClient&quot;<wbr /> /&gt;<br />
<br />
^ for example.<br />
<br />
Then have another section where you configure which to select<br />
&lt;add key=&quot;MyConnectionToPick&quot; value=&quot;myGG2&quot;/&gt;<br />
<br />
So in your code instead of stating you want specifically &quot;myGG2&quot; you say you want the connection stated in MyConnectionToPick.
</div>


Why not have different keys but have different names?  

<add name="myGG1" connectionString="Data Source=myDataBase;Initial Catalog=myGG;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="myGG2" connectionString="Data Source=myDataBase;Initial Catalog=myGG;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="myGG3" connectionString="Data Source=myDataBase;Initial Catalog=myGG;Integrated Security=True" providerName="System.Data.SqlClient" />

^ for example.

Then have another section where you configure which to select
<add key="MyConnectionToPick" value="myGG2"/>

So in your code instead of stating you want specifically "myGG2" you say you want the connection stated in MyConnectionToPick.

<div>
Please watch for follow-up questions
</div>


<div>
<div class="content wysiwyg-content">
Is there a way to save my data source keys in a text file list which the Web.Config reads?<br />
<br />
If not...what is the best way of adding an appsetting data source name like the one below without having to kick anyone off of the server?<br />
<br />
&lt;add name=&quot;myGG&quot; connectionString=&quot;Data Source=myDataBase;Initial Catalog=myGG;Integrated Security=True&quot; providerName=&quot;System.Data.<wbr />SqlClient&quot;<wbr /> /&gt;
</div>
</div>


Is there a way to save my data source keys in a text file list which the Web.Config reads?

If not...what is the best way of adding an appsetting data source name like the one below without having to kick anyone off of the server?

<add name="myGG" connectionString="Data Source=myDataBase;Initial Catalog=myGG;Integrated Security=True" providerName="System.Data.SqlClient" />

App Setting Data Key

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.