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.
Unfortunately, activation email could not send to your email. Please try again.

Showing SQL Server data in schedule control

Thread ID:





123534 Mar 27,2016 12:28 PM Mar 28,2016 09:58 AM Windows Forms 1
Tags: ScheduleControl
Asked On March 27, 2016 12:28 PM

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 [Syncfusion]
Replied On March 28, 2016 09:58 AM

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:
<Installed Location>\Syncfusion\EssentialStudio\<Version Number>\Windows\Schedule.Windows\Samples\Scheduler Demo\CS



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.