Defining ConnectionString in asp SqlDataSource
<p>I have my database connectivity which I define under <code>&lt;appSettings&gt;</code> in <code>web.comfig</code>:</p>

<pre><code>&lt;appSettings&gt;
    &lt;add key="ConnStr" 
         value="Data Source=dsk-159\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"/&gt;
&lt;/appSettings&gt;
</code></pre>

<p>But the problem is that I am unable to access it from my aspx page as I am trying like this</p>

<pre><code>&lt;asp:SqlDataSource ID="SqlDataSource2" runat="server" 
     ConnectionString="&lt;%$ ConnectionStrings:goldsConnectionString %&gt;"
     SelectCommand="SELECT distinct TechnologyId , [TechnologyName], [ChildId] FROM [TreeTable] where childid is null AND technologyid in(@hid1)"&gt;
     &lt;SelectParameters&gt;
         &lt;asp:ControlParameter ControlID="hid1" Name="hid1" DefaultValue="23" /&gt;
     &lt;/SelectParameters&gt;
</code></pre>

<p>In place of <code>&lt;connectionStrings&gt;</code> I want to define it in <code>&lt;appSettings&gt;</code> </p>

<p>Plesae tell the correct syntax.</p>
