To generate Scheduler from the Views of SQL Server, refer to the below step-by-step procedure.
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;
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.
This page will automatically be redirected to the sign-in page in 10 seconds.