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.

To generate Schedule based upon a view in SQL Server

To generate Scheduler from the Views of SQL Server, refer to the below step-by-step procedure.

  1. Create a new View from the already existing tables in SQL Server by using the below depicted code.

Create view ScheduleView AS select scheduler.CalendarID, scheduler.Subject,scheduler.StartTime, scheduler.EndTime as EndTime,scheduler.AllDay, scheduler.Recurrence,scheduler.RecurrenceRule, scheduler.StaffID,scheduler.JobID,scheduler.Comments from StaffCalendar scheduler Inner Join Staff staff on scheduler.StaffID=staff.StaffID Inner Join Job job on scheduler.JobID =job.JobID;

  1. Create a LightSwitchHTML project and render the Schedule control in it. (Refer Here)

 

  1. Right click the Data Source folder. Select the Database option and click Next button.

 

 

 

4)      Now, select the path where your newly created view is present.

 

 

 

5) From the listed tables and views, select the required view name and click Finish button. 

 

 

 

6)      The selected View is added under the Data Sources folder and now you can refer it wherever you want in your project just similar to the tables.

 

http://www.syncfusion.com/downloads/support/directtrac/150772/1229550163_909c77ec.PNG 

Sample Link:

http://www.syncfusion.com/downloads/support/directtrac/150772/ze/CalendarTest-933843674

Article ID: Published Date: Last Revised Date: Platform: Control: .NET Framework:
6549 03/15/2016 03/15/2016 LightSwitch HTML Schedule 4.5
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.