[Solved] Display Image or data in cell based on value returned from database

[Steve Napurano]

Hi. I am looking into how to display an image or data in a grid cell based on the value returned from the database.

For instance, if value > 0, display image...if value = 0, display 0

Any insight would be beneficial to me for I am a new member to the Telerik suite.

[Shinu]

Hi Steve,

Try the following approach by placing image control and Label control in GridTemplateColumn of RadGrid and set the visibility of these controls according to the cell value.

ASPX:

<telerik:GridTemplateColumn UniqueName="CopyEmail" HeaderText="Copy?">
    <ItemTemplate>
        <asp:Label ID="Label1" runat="server" Text="0" Visible='<%# (Convert.ToInt32(Eval("Number"))) == 0 ? true : false %>'></asp:Label>
        <asp:Image ID="Image1" runat="server" ImageUrl="~/Images/Image1.gif" Visible='<%# Convert.ToInt32(Eval("Number")) > 0 ? true : false %>' />
    </ItemTemplate>
    <EditItemTemplate>
    </EditItemTemplate>
</telerik:GridTemplateColumn>

-Shinu.

[Steve Napurano]

Hi, this is giving me a syntax error when I compile..

Visible

 

='<%# Convert.ToInt32(Eval("1")) > 0 ? true : false %>' />

 

I really wanted this but I wanted to try a basic hard coded example (Above)

Visible

 

='<%# Convert.ToInt32(Eval(Container, "DataItem.Unitpack")) > 0 ? true : false %>' />

Getting syntax errors. Any ideas?

Thanks man...

 

[Sebastian]

Hello Steve,

In case you develop in VB.NET language, you will need to modify the code slice as follows:

Visible ='<%# IIF(Integer.Parse(Eval(Container, "DataItem.Unitpack")) > 0,  True, False) %>' />

Thus you should eliminate the syntax errors.

Best regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Steve Napurano]

Thank you sir...