Hi
I am new to using Scheduler with Group By resources. I have created the page with all the necessary data. But the Scheduler displays multiple entries for the resources.
![]()
You can see my multiple appointments for resource Mary, though there is only one entry in the database
My Server side code as follows:
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If Not IsPostBack Then
'Dim ParamCol = New ParameterCollection
'ParamCol.Add("Date", Now)
Dim ds As DataSet = zDataFactory.GetAppointmentListAll()
RadScheduler1.SelectedDate = Convert.ToDateTime(Now)
RadScheduler1.SelectedView = SchedulerViewType.DayView
RadScheduler1.TimelineView.NumberOfSlots = 10
RadScheduler1.DataSource = ds
RadScheduler1.DataKeyField = "AppointmentID"
RadScheduler1.DataStartField = "FromTime"
RadScheduler1.DataEndField = "ToTime"
RadScheduler1.DataSubjectField = "ServiceDescription"
RadScheduler1.GroupBy = "Consultant"
RadScheduler1.GroupingDirection = GroupingDirection.Horizontal
Dim rt As New ResourceType("Consultants")
rt.ForeignKeyField = "ConsultantID"
rt.KeyField = "ConsultantID"
rt.TextField = "ConsultantName"
rt.Name = "Consultant"
rt.AllowMultipleValues = False
rt.DataSource =zDataFactory.GetConsultantList()
RadScheduler1.ResourceTypes.Add(rt)
End If
End Sub
The data this is returned by the zDataFactory.GetAppointmentListAll()
![]()
Where it is going wrong?