Change background color of appointments

[Kevin]

Ok, I have gone through the documentation and differetn posts but cannot find an eample that shows for my situation.  i want to change the background color of an ID that comes from my database.  I am bring the intstatusID from my database, where can I assign it that I can get ahold of that value and then change the background color of it based on the value.  thank you

<telerik:RadScheduler ID="rsTACCUsage" runat="server" DataKeyField="intLeaseDateId" Skin="Web20" DataStartField="dtStartDate" DataEndField="dtEndDate" DataSubjectField="Subject"
                           SelectedView="MonthView" Height="800px" AllowEdit="false" AllowInsert="false" AllowDelete="false" CustomAttributeNames="strOrgType">
                       </telerik:RadScheduler>



sql = "select d.intLeaseDateId, d.dtStartDate, d.dtEndDate, 'Lease Name: ' + l.strLeaseeName + '  Event: ' + l.strEventType Subject, l.intStatusID from tblLeaseDates d LEFT JOIN tblTaccLease l on l.intLeaseId = d.intLeaseId where l.intArmoryId = " & Armory

           rsTACCUsage.DataSource = getReader(sql)
           rsTACCUsage.DataBind()

[Boyan Dimitrov]

Hello,

In this case I would suggest using the RadScheduler AppointmentDataBound event handler. This event is fired for each appointment and you have access to the appointment DataItem. This object represents the underlying data object to which the appointment object is bound. In other words using this object you can access the values that comes from the data base.


Regards,
Boyan Dimitrov
Telerik