Dears, i am displaying information from a database using SqlDataSource and datalist, the database is showing 3 fields, an image and 2 labels. How can i hide the image if the value from the database id null.

the SQL DATASOURCE is:

<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:peaceConnectionString1 %>"
SelectCommand="SELECT [newsid], [newstitle], [adddate], [news], [newspic] FROM [news] WHERE ([newsid] = @newsid)"><SelectParameters>
<asp:QueryStringParameter Name="newsid" QueryStringField="newsid" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>

The Datalist is:

    <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
        <ItemTemplate>
            <table style="width: 720px">
                <tr>
                    <td style="width: 720px; text-align: center">
                        <asp:Image ID="Image2"
                        runat="server"
                        ImageUrl='<%# Eval("newspic", "images/news/{0}") %>'
                        BorderColor="White"
                        BorderWidth="2px"
                        Visible='<%# Eval("newspic") %>'

                        />
                        <br />

                    </td>
                </tr>
                <tr>
                    <td style="width: 720px; text-align: left">
                        <asp:Label ID="adddateLabel" runat="server" Text='<%# Eval("adddate", "{0:d}") %>' CssClass="blue12"></asp:Label><br />
                        <asp:Image ID="Image1" runat="server" ImageUrl="~/images/arr.gif" />&nbsp;
                        <asp:Label ID="Label2" runat="server" CssClass="sitetext" Text='<%# Eval("newstitle") %>' Font-Bold="True"></asp:Label>
                        <br />
                        <br />
                        <asp:Label ID="Label1" runat="server" CssClass="sitetext" Text='<%# Eval("news", "{0}") %>'></asp:Label><br />
                        &nbsp;</td>
                </tr>
                <tr>
                    <td style="width: 720px; text-align: left">
                    </td>
                </tr>
                <tr>
                    <td style="width: 720px; height: 18px; text-align: center">
                        <asp:HyperLink ID="HyperLink1" runat="server" CssClass="copyright" NavigateUrl="~/news.aspx">Back to News</asp:HyperLink></td>
                </tr>
            </table>
            &nbsp;
        </ItemTemplate>
    </asp:DataList>

Well one approach could be the ItemDataBound event of datalist, the code could be as below:

protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                if (DataBinder.Eval(e.Item.DataItem, "newspic") == DBNull.Value)
                {
                    ((Image)e.Item.FindControl("Image2")).Visible = false;
                }
            }
        }

Regards
Mike

Don't expect too much, too soon.

I need the code in VB, please reply