-
March 3rd, 2013, 11:19 AM
#1
Totaaly confused newbie - please be kind
I am attempting to show or not show some text on a web page based upon a row count in and MSSQL table. The SELECT statment returns some value where one column contains "DISPLAY" or not. This id the number of rows containing "DISPLAY" are zero I DO NOT wish to display the content.
SO what I cam up with is -
<form>
<asp:SqlDataSource id="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:xyzDB %>" SelectCommand="SELECT COUNT(xEmerStatus) FROM xyzTABLE WHERE xEmerStatus = 'DISPLAY'">
</asp:SqlDataSource>
<aspataList id="DataList5" runat="server" DataSourceID="SqlDataSource5">
<ItemTemplate>
<asp:Label id="Column1Label" runat="server" Text='<%# Eval("Column1") %>' />
</ItemTemplate>
</aspataList>
<%
If DataBinder.Eval(Container.DataItem,"Column1") = 0 Then
%>
display code here
<%
End If
%>
</form>
Thus the question is how can I change the returned value to an integer and "test" is againt the zero ?
MANY THANKS for your assiatance.
-
March 3rd, 2013, 06:13 PM
#2
Re: Totaaly confused newbie - please be kind
First, determine the value that actually exists in the statement "DataBinder.Eval(Container.DataItem,"Column1")"
I doubt that it returns 0. Might be True/False even
-
March 3rd, 2013, 07:10 PM
#3
Re: Totaaly confused newbie - please be kind
Well I know the SELECT returns a zero (0).Not sure how to show what this code is returning however.
-
March 3rd, 2013, 10:02 PM
#4
Re: Totaaly confused newbie - please be kind
In your WHERE SQL Statement. NOT = 0 (Might be FALSE)
That will return the TRUE ones
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|