title: ASP.Net AppSettings in Command of SqlDataSource
body: <p>I have a <code>SqlDataSource</code> that I am trying to set an insert command with additional text after every table to switch for testing. I wanted to do this with an <code>&lt;appSetting&gt;</code> in the <code>web.config</code>.</p>
  
  <p>When I do the following</p>
  
  <pre><code>&lt;asp:SqlDataSource ID="SqlDataSourceDRDocument" runat="server" 
      ConnectionString="&lt;%$ ConnectionStrings:ISNORTHConnectionString %&gt;" 
      ProviderName="System.Data.SqlClient"          
      InsertCommand="insert into DR_Document&lt;%$ AppSettings:tablename %&gt;
      (Columns) Values (Values)"&gt;
  &lt;asp:SqlDataSource&gt;
  </code></pre>
  
  <p>I get</p>
  
  <blockquote>
    <p>Invalid object name 'DR_Division&lt;%$ AppSettings:tablename %>' </p>
  </blockquote>
  
  <p>What am I doing wrong?</p>