Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • 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"

                                                    DataSourceID="SqlDataSource2" ResourceDataSourceID="SqlDataSource2"

                                                    Start="2007-12-06">

                                                    <Storage>

                                                        <Resources>

                                                            <Mappings ResourceId="IDNO" Caption="PFIRST" />

                                                        </Resources>

                                                        <Appointments>

                                                            <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="""" />

                                                        </Appointments>

                                                    </Storage>

                                                    <Views>

                                                        <WorkWeekView>

                                                            <TimeRulers>

                                                                <cc1:TimeRuler>

                                                                </cc1:TimeRuler>

                                                            </TimeRulers>

                                                        </WorkWeekView>

                                                        <DayView TimeScale="00:15:00">

                                                            <TimeRulers>

                                                                <cc1:TimeRuler>

                                                                </cc1:TimeRuler>

                                                            </TimeRulers>

                                                        </DayView>

                                                    </Views>

                                                    <OptionsCookies Enabled="True" />

                                                    <OptionsView ShowOnlyResourceAppointments="True" />

                                                </dxwschs:ASPxScheduler>

                                                <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)">

                                                    <SelectParameters>

                                                        <asp:Parameter DefaultValue="1" Name="TYPE" Type="Byte" />

                                                    </SelectParameters>

                                                </asp:SqlDataSource>

                                    Actual Results:

                                    No resources are shown sometimes and all the appointments are displayed for all dates and resources.

                                    Expected Results:

                                    The resources grouping should appear and the appointments should be properly grouped and displayed

                                NoResources.JPG
                                0

                                Hello Brad,

                                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:

                                Label="0" AllDay="false"

                                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.

                                Thank you,
                                Alex.

                                To start a chat you should create a support ticket


                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners