Articles in this section
Category / Section

To generate Schedule based upon a view in SQL Server

1 min read

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;

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

 

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

 

Data source folder 

 

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

 

Select path 

 

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

 

Attach data source wizard 

 

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:

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

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied