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.
Syncfusion Feedback

Showing SQL Server data in schedule control

Thread ID:

Created:

Updated:

Platform:

Replies:

123534 Mar 27,2016 04:28 PM UTC Mar 28,2016 01:58 PM UTC WinForms 1
loading
Tags: ScheduleControl
Thomas
Asked On March 27, 2016 04:28 PM UTC

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 [Syncfusion]
Replied On 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


CONFIRMATION

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.

Warning Icon 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.Close Icon

;