title: ASP.NET DataSource with parameters for SQL IN clause
body: <pre><code>&lt;asp:SqlDataSource ID="DataSource1" runat="server" 
      ConnectionString="&lt;%$ ConnectionStrings:DbConnection %&gt;" 
      ProviderName="&lt;%$ ConnectionStrings:DbConnection.ProviderName %&gt;" 
      SelectCommand="select somefield from sometable where somefield in (?)"&gt;
      &lt;SelectParameters&gt;
          &lt;asp:Parameter DefaultValue="" Name="SomeFiedValue" /&gt;
      &lt;/SelectParameters&gt;
  &lt;/asp:SqlDataSource&gt;
  </code></pre>
  
  <p>How (from my codebehind) do I allocate a list of values for the parameter in the above SQL query?</p>