Showing SQL Server data in schedule control

[Thomas]

Hi,

Is it possible to show values of a SQL Server 2014 table in schedulecontrol using a datatable? Without using model classes? 

The table got the following fields

1. ID
2. Hall Name
3. Booked By
4. Booking Type 
5. Start Date
6. End Date
7. Notes

Can we show the bookings in the control just by calling a select statement and filling into a datatable and then assign the datatable to the control as datasource? I like to show the booking in the control in different colors based on the type column value. Possible? Please help me out here. 

[Piruthiviraj Malaimelraj]

Hi Thomas,

 

Thank you for using Syncfusion products.

The schedule control have all its databases through interfaces. The IScheduleDataProvider interface provides methods to customize a database file to be assigned to the Schedule Control.
The booked appointments are done and retrieved through the  ScheduleAppointment class, which provides the booked appointments and the new appointments
and the desired color value can be set through the appointments form.  

Please refer to the below UG document  and the KB links for changing styles to the  data in the  schedule control .
UG Link:
http://help.syncfusion.com/windowsforms/schedule/getting-started#data-used-by-schedulecontrol 
KB:
https://www.syncfusion.com/kb/4262/How-to-set-the-backcolor-for-all-appoinment-dates-in-calendar
Sample:
<Installed Location>\Syncfusion\EssentialStudio\<Version Number>\Windows\Schedule.Windows\Samples\Scheduler Demo\CS

Regards,
Piruthiviraj