title: Defining ConnectionString in asp SqlDataSource
body: <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>