Displaying Image from SQL in Appointment

[Robert]

Trying to display a Image from a SQL database, using the BinaryImage Control.  For some reason it doesn't display the image.

 

<ResourceTypes>

 

 

        <telerik:ResourceType DataSourceID="SqlDataSource1" ForeignKeyField="IMAGE"

 

 

            KeyField="IMAGE" Name="IMAGE" TextField="IMAGE" />

 

 

 

        </ResourceTypes>

 

 

<AppointmentTemplate>

 

 

    <h3>

 

        <%

# Eval("Subject") %>

 

 

    </h3>

 

 

    <telerik:RadBinaryImage ID="RadBinaryImage1" runat="server" DataValue='<%# Bind("IMAGE") %>'

 

 

        ImageHeight="20px" ImageWidth="20px" ResizeMode="Fit"/>

 

 

</AppointmentTemplate>

 

[Robert]

I think I know where my problem is at now, just don't know how to fix it.  It appears that I didn't set up the ResourceType correctly, but I don't see what I have wrong. 

 

<ResourceTypes>

 <telerik:ResourceType KeyField="UniqueKey" Name="IMAGE" TextField="IMAGE" ForeignKeyField="IMAGE"

 DataSourceID="ImageDataSource" />

 </ResourceTypes>
 

<

 

asp:SqlDataSource ID="ImageDataSource" runat="server"

 

 

ProviderName="System.Data.SqlClient" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

 

 

 

SelectCommand="SELECT UniqueKey, IMAGE FROM CALENDAR">

 

 

 

</asp:SqlDataSource>

 

[Ivana]

Hello Robert,

The resources of RadScheduler take strings as a value whereas the DataValue property of RadBinaryImage takes byte[] as a value.
The following online demo shows an example of how to show the resources in an appointment template: http://demos.telerik.com/aspnet-ajax/scheduler/examples/customizeappointment/defaultcs.aspx.

Take a look RadBinaryImage's online demos for more information how to use it: http://demos.telerik.com/aspnet-ajax/binaryimage/examples/overview/defaultcs.aspx.

Regards,
Ivana
the Telerik team

[Robert]

Is there a way to take the resourcetype field and convert it to a byte[] type?  That way it can be used as the input for the BinaryImage