We had purchased the control recently and aim to create a page where the user can view the schedules. We already have a database of an ERP where all the tasks and appointments are stored. For creating the appointments the ERP application is used. So here on the web page we are creating we are just fetching the data from the ERP database and trying to bind it to the ASPxScheduler data sources. We tried binding the data sources at Design time as well as in the code behind.
The problem is sometimes the resources are shown and suddenly the resources grouping disappears. All the appointments are fetched and shown and no grouping of the appointments is done on date though the date does appear unlike the resources.
Steps to Reproduce:
Below is the sample design time source binding that we tried, I hope it will help you to reproduce the problem
<dxwschs:ASPxScheduler ID="ASPxScheduler1" runat="server" AppointmentDataSourceID="SqlDataSource1"
<Mappings ResourceId="IDNO" Caption="PFIRST" />
<Mappings AppointmentId="TASK_ID" End="END_DATE" ResourceId="USERREMIND" Start="START_DATE" Status="STATUS" Subject="SUBJECT" Type="TYPE" Description="NOTE" Label="0" AllDay="false" RecurrenceInfo="""" ReminderInfo="""" />
<OptionsCookies Enabled="True" />
<OptionsView ShowOnlyResourceAppointments="True" />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:EVEREST_SAMPLEConnectionString %>"
SelectCommand="SELECT [IDNO], [PLAST], [PFIRST] FROM [PERSONAL]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:EVEREST_SAMPLEConnectionString %>"
SelectCommand="SELECT TASK_ID, USERREMIND, SUB_CODE, SUBJECT, START_DATE, END_DATE, TYPE, STATUS, NOTE FROM TASKS WHERE (TYPE = 1)">
<asp:Parameter DefaultValue="1" Name="TYPE" Type="Byte" />
No resources are shown sometimes and all the appointments are displayed for all dates and resources.
The resources grouping should appear and the appointments should be properly grouped and displayed
Thanks for the report. According to the information you provided, it seems that the problem might be related to Appointment mappings defined in the ASPX code you posted. Please confirm that you didn't change ASPX content.
See the following code snippet:
That is, instead of field names, Label and AllDay properties are directly mapped to particular values. Please fix appointment mappings, and also check that you are using an appropriate field type to save the "USERREMIND" data. See the "Which database structure to use with the XtraScheduler control?" Knowledge base article for details (www.devexpress.com/kb=A2951).
Please let me know your result.
Is your intention to post an answer to your own question?
- If so, then proceed.
- If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
- If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.