We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Showing SQL Server data in schedule control

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. 





1 Reply

PM Piruthiviraj Malaimelraj Syncfusion Team March 28, 2016 01:58 PM UTC

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


Loader.
Live Chat Icon For mobile
Up arrow icon