asp:sqldatasource SelectCommandType="Text" Dropdown not populating ONLY when parameters are passed to SQL
<p>I'm trying to use a <code>asp:SqlDataSource</code> driven by a SQL Select with Arguments. It works as long as I don't have any arguments.  I can run the parameterized query via studio and it works and returns rows.  If I any arguments, then the <code>asp:View</code> doesn't render.</p>

<p>First, the code returns 2 rows when I execute the SQL via Studio.
Second, I don't want it as a stored proc.  Deployment issue.  Smile, let it go. :-) </p>

<hr>

<pre><code>&lt;asp:DropDownList ID="lstUsers" runat="server" DataSourceID="sqlGetCSGUsersOnClaim" DataTextField="username" DataValueField="userID" /&gt;

&lt;asp:SqlDataSource ID="sqlGetCSGUsersOnClaim" runat="server" ConnectionString="&lt;%$ ConnectionStrings:SiteSqlServer%&gt;" SelectCommandType="Text" SelectCommand="
SELECT aspnet_Users.UserId as userID, aspnet_users.username as username
FROM claims, aspnet_Users
WHERE claims.claimid = @ClaimID and 
(Claims.AdjusterID = aspnet_Users.UserId or Claims.SupervisorID = aspnet_Users.UserId )"&gt;
&lt;SelectParameters&gt;
   &lt;asp:SessionParameter Name="ClaimID" SessionField="ClaimID" Type="Int32" DbType="Int32" /&gt;
&lt;/SelectParameters&gt;
&lt;/asp:SqlDataSource&gt;
</code></pre>

<hr>

<p>If I remove the <code>@ClaimID</code> and <code>SelectParameters</code> arguments, the dropdown populates.  It only fails once I add the parameter.</p>

<p>What am I doing wrong?</p>

<p>Thanks in advance,
Jason</p>
