Hello Telerik Team,
I have a requirement where i need to bind the scheduler to a sql database table and display some columns
from the table on top of the cell.I mean by default scheduler just shows up the subject on the cell but i wanted to display some additional columns from database example priority column, Description column,etc on top of each cell instead of the edit template.At the same time i need to colour code the cell based on the status column values.
I have connected the scheduler to sql datasource already and able to fetch the information.
Any pointers in this direction are greatly appreciated.
Thank you
Smith
2 Answers, 1 is accepted
You can display any extra information about an appointment using AppointmentTemplate as shown in the following demos: Using Templates and Resource Availability.
Greetings,
Peter
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Rank 1
I found the reference you showed me as useful.
I was able to show the coulmns from the database table on top of my rad scheduler cell by using
<
AppointmentTemplate>
<b>Subject:</b><%#Eval("Subject") %>
<br />
<b>STATUS:</b><%#Eval("STATUS")%>
</AppointmentTemplate>
in my ascx.
I used the above snippet to do it.
I was able to colour code the appointment based on the status using
protected void RadScheduler1_AppointmentDataBound(object sender, SchedulerEventArgs e)
{
if (e.Appointment.Attributes["STATUS"] == "Approved")
{
e.Appointment.BackColor = System.Drawing.
Color.Red;
}
else if (e.Appointment.Attributes["STATUS"] == "Pending")
{
e.Appointment.BackColor = System.Drawing.
Color.Green;
}
else
{
e.Appointment.BackColor = System.Drawing.
Color.Turquoise;
}
}
here the "STATUS" is the exact column name of the database table.
Thank you For your support.
Smith