I have an sqldatasource in my asp.net site that has a parameter it gets from a control on the page.  When I set the query on a  number data column in the DB the datasource works perfect.  However when I write the query on a string (char or varchar) column in the DB it doesn't work.  I made sure all the parameters are correct in the datasource.  This is for an Oracle 11g database -- Below is my code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:XXXXXX %>"
ProviderName="<%$ ConnectionStrings:XXXXXX %>"
                                        
SelectCommand="SELECT &quot;IMAGEURL&quot;, &quot;PRODUCTNAME&quot;, &quot;MINHEIGHT&quot;, &quot;MINWIDTH&quot;
FROM &quot;PRODUCT&quot;
WHERE (&quot;PRODUCTNAME&quot; = :PRODUCT)">
                                        
<SelectParameters>
<asp:ControlParameter ControlID="Label3" Name="PRODUCT" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

The previous is for the string column that doesn't show any items.  Below is the decimal or number column that does shot items.

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
ConnectionString="<%$ ConnectionStrings:XXXXXX %>" 
ProviderName="<%$ ConnectionStrings:XXXXXX %>" 
                                        
SelectCommand="SELECT &quot;IMAGEURL&quot;, &quot;PRODUCTNAME&quot;, &quot;MINHEIGHT&quot;, &quot;MINWIDTH&quot; 
FROM &quot;PRODUCT&quot; 
WHERE (&quot;PRODUCTID&quot; = :PRODUCT)">
                                        
<SelectParameters>
<asp:ControlParameter ControlID="Label3" Name="PRODUCT" PropertyName="Text" Type="Decimal" />
</SelectParameters>
</asp:SqlDataSource>