Difficulties with Selectparameters

[ray.ragan]

Forum,

I have a query with a Selectparameter, however my Selectparameter is not always present, and in that case, I would like the query to return all records.

I'm using a column called status for the parameter. Status is an tinyint that IS NOT NULL.

Psuedo code:

<asp:SqlDataSource ID="sqlMy" runat="server" ConnectionString="<%$ ConnectionStrings:myConnStr%>"
SelectCommand="SELECT *, FROM [myTbl] WHERE status = @status">
<SelectParameters>
<asp:QueryStringParameter Name="status" QueryStringField="status" DefaultValue="" />
</SelectParameters>
</asp:SqlDataSource>

Suggestions?

Thank you,

Ray K. Ragan

 

[ray.ragan]

Forum,

I got it:

<asp:SqlDataSource ID="sqlMy" runat="server" ConnectionString="<%$ ConnectionStrings:MyConStr%>"
SelectCommand="SELECT *, FROM [myTbl] WHERE (@status = '' OR status = @status)">
<SelectParameters>
<asp:QueryStringParameter Name="status" QueryStringField="status" DefaultValue="" ConvertEmptyStringToNull="false" />
</SelectParameters>
</asp:SqlDataSource>

Thank you,

Ray K. Ragan