2 GridPanel with Store.reload() locking up browser

  1. #1

    2 GridPanel with Store.reload() locking up browser

    I have 2 grid panels that are refreshed using Store.reload();
    The browser locks up. Take 1 gridpanel away, everything work fine...am I doing something wrong?
        <ext:ScriptManager ID="ScriptManager1" runat="server">
        </ext:ScriptManager>
        <ext:Hidden runat="server" id="hidEntityId">
        </ext:Hidden>
        <ext:Hidden runat="server" id="hidReportTitleId">
        </ext:Hidden>
        <asp:SqlDataSource ID="fundSource" runat="server" ConnectionString="<%$ ConnectionStrings:WarehouseConnectionString %>" SelectCommand="SELECT     DISTINCT(WorkflowReport.EntityId), Funds.FundName FROM         Funds RIGHT OUTER JOIN WorkflowReport ON Funds.FundId = WorkflowReport.EntityId WHERE WorkflowReport.EntityId IS NOT NULL ORDER BY FUNDNAME"></asp:SqlDataSource>
        <ext:Store runat="server" ID="fundStore" datasourceid="fundSource">
            <Reader>
                <ext:JsonReader readerid="EntityId">
                    <Fields>
                        <ext:RecordField Name="EntityId" Type="Int" />
                        <ext:RecordField Name="FundName" Type="String" />
                    </Fields>
                </ext:JsonReader>
            </Reader>
        </ext:Store>
        <asp:SqlDataSource ID="reportSource" runat="server" ConnectionString="<%$ ConnectionStrings:WarehouseConnectionString %>" SelectCommand="SELECT ReportTitleId, Title FROM ReportTitle"></asp:SqlDataSource>
        <ext:Store runat="server" ID="reportStore" datasourceid="reportSource">
            <Reader>
                <ext:JsonReader readerid="ReportTitleId">
                    <Fields>
                        <ext:RecordField Name="ReportTitleId" Type="Int" />
                        <ext:RecordField Name="Title" Type="String" />
                    </Fields>
                </ext:JsonReader>
            </Reader>
        </ext:Store>
        <ext:FormPanel runat="server" id="FormPanel1" title="Find Workflows">
            <Body>
                <ext:FormLayout runat="server" id="FormLayout">
                    <ext:Anchor>
                        <ext:ComboBox runat="server" typeahead="true" mode="local" width="400" fieldlabel="Funds" id="cmboFundId" storeid="fundStore" DisplayField="FundName" ValueField="EntityId">
                            <Listeners>
                                <Select fn="SetEntityValue" />
                                <Change fn="SetEntityValue" />
                            </Listeners>
                        </ext:ComboBox>
                    </ext:Anchor>
                    <ext:Anchor>
                        <ext:ComboBox runat="server" typeahead="true" mode="local" select&#111;nfocus="true" forceselection="true" Resizable="true" width="150" fieldlabel="Reports" id="cmbReports" storeid="reportStore" DisplayField="Title" ValueField="ReportTitleId">
                            <Listeners>
                                <Change fn="SetReportValue" />
                                <Select fn="SetReportValue" />     
                                
                                
                            </Listeners>
                        </ext:ComboBox>
                    </ext:Anchor>
                    <ext:Anchor>
                        <ext:Button runat="server" id="btnFind" icon="Magnifier" Text="Find">
                            <Listeners>
                                <Click Handler="#{workflowStore}.reload(); #{clientStore}.reload();" />
                            </Listeners>
                        </ext:Button>
                    </ext:Anchor>
                </ext:FormLayout>
            </Body>
        </ext:FormPanel>
        <asp:SqlDataSource ID="workflowSource" runat="server" ConnectionString="<%$ ConnectionStrings:WarehouseConnectionString %>" SelectCommand="
    SELECT     WorkflowReport.WorkflowReportId, WorkflowReport.WorkflowSoeId, WorkflowReport.DueDate, WorkflowReport.StatusId, WorkflowReport.IsActive, 
                          WorkflowReport.Repetition, WorkflowReport.CreatedOn, WorkflowReport.CreatedBy, WorkflowReport.ModifiedOn, WorkflowReport.ModifiedBy, 
                          Status.StatusName
    FROM         WorkflowReport INNER JOIN
                          Status ON WorkflowReport.StatusId = Status.StatusId
    WHERE     (WorkflowReport.ReportTitleId = @reportTitleId) AND (WorkflowReport.EntityId = @entityId)
    ">
            <SelectParameters>
                <asp:Parameter name="reportTitleId" Direction="input" DefaultValue="1" Type="Int32" />
                <asp:Parameter name="entityId" Direction="input" DefaultValue="1" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="clientSource" runat="server" ConnectionString="<%$ ConnectionStrings:WarehouseConnectionString %>" SelectCommand="
    SELECT     ClientReport.ClientReportId, Client.ClientName,ClientReport.IsActive,ClientReport.CreatedOn,ClientReport.CreatedBy
    FROM         ClientReport INNER JOIN
                          Client ON ClientReport.ClientId = Client.ClientId
    WHERE     (ClientReport.EntityId = entityId) AND (ClientReport.ReportTitleId = reportTitleId)
    ">
            <SelectParameters>
                <asp:Parameter name="reportTitleId" Direction="input" DefaultValue="1" Type="Int32" />
                <asp:Parameter name="entityId" Direction="input" DefaultValue="1" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <ext:Store runat="server" ID="workflowStore" datasourceid="workflowSource" onrefreshdata="Workflow_RefreshData">
            <BaseParams>
                <ext:Parameter Name="reportTitleId" Value="#{hidReportTitleId}.getValue()" Mode="Raw" />
                <ext:Parameter Name="entityId" Value="#{hidEntityId}.getValue()" Mode="Raw" />
            </BaseParams>
            <Reader>
                <ext:JsonReader readerid="WorkflowReportId">
                    <Fields>
                        <ext:RecordField Name="WorkflowReportId" Type="Int" />
                        <ext:RecordField Name="WorkflowSoeId" Type="String" />
                        <ext:RecordField Name="DueDate" type="Date" />
                        <ext:RecordField Name="IsActive" type="Boolean" />
                        <ext:RecordField Name="Repetition" type="Boolean" />
                        <ext:RecordField Name="StatusName" Type="String" />
                        <ext:RecordField Name="CreatedOn" Type="Date" />
                        <ext:RecordField Name="CreatedBy" Type="String" />
                    </Fields>
                </ext:JsonReader>
            </Reader>
        </ext:Store>
        <ext:Store runat="server" ID="clientStore" datasourceid="clientSource" onrefreshdata="Client_RefreshData">
            <BaseParams>
                <ext:Parameter Name="reportTitleId" Value="#{hidReportTitleId}.getValue()" Mode="Raw" />
                <ext:Parameter Name="entityId" Value="#{hidEntityId}.getValue()" Mode="Raw" />
            </BaseParams>
            <Reader>
                <ext:JsonReader readerid="ClientReportId">
                    <Fields>
                        <ext:RecordField Name="ClientReportId" Type="Int" />
                        <ext:RecordField Name="ClientName" Type="String" />
                        <ext:RecordField Name="DueDate" type="Date" />
                        <ext:RecordField Name="IsActive" type="Boolean" />
                        <ext:RecordField Name="CreatedOn" Type="Date" />
                        <ext:RecordField Name="CreatedBy" Type="String" />
                    </Fields>
                </ext:JsonReader>
            </Reader>
        </ext:Store>
     
                        <ext:GridPanel id="GridPanel13F" header="true" title="Workflows" autodatabind="true" autoheight="true" runat="server" border="false"  width="600" striperows="true" trackmouseover="true" storeid="workflowStore">
                            <LoadMask ShowMask="true" Msg="Loading Workflows..." />
                            <AutoLoad AutoDataBind="false" showmask="true" />
                            <ColumnModel id="ColumnModel1" runat="server">
                                <Columns>
                                    <ext:Column ColumnID="WorkflowSoeId" DataIndex="WorkflowSoeId" Header="WorkflowSoeId" Align="Left" Groupable="true" Sortable="true">
                                    </ext:Column>
                                    <ext:Column ColumnID="DueDate" DataIndex="DueDate" Header="DueDate" Align="Center" Groupable="true" Sortable="true">
                                        <Renderer Fn="Ext.util.Format.dateRenderer('m/d/Y')" />
                                    </ext:Column>
                                    <ext:Column ColumnID="IsActive" DataIndex="IsActive" Header="IsActive" Align="Center" Groupable="true" Sortable="true">
                                    </ext:Column>
                                    <ext:Column ColumnID="Repetition" DataIndex="Repetition" Header="Repetition" Align="Center" Groupable="true" Sortable="true">
                                    </ext:Column>
                                    <ext:Column ColumnID="StatusName" DataIndex="StatusName" Header="StatusName" Align="Center" Groupable="true" Sortable="true">
                                    </ext:Column>
                                    <ext:Column ColumnID="CreatedOn" DataIndex="CreatedOn" Header="CreatedOn" Align="Center" Groupable="true" Sortable="true">
                                        <Renderer Fn="Ext.util.Format.dateRenderer('m/d/Y')" />
                                    </ext:Column>
                                    <ext:Column ColumnID="CreatedBy" DataIndex="CreatedBy" Header="CreatedBy" Align="Center" Groupable="true" Sortable="true">
                                    </ext:Column>
                                </Columns>
                            </ColumnModel>
                        </ext:GridPanel>
        <ext:GridPanel id="GridPanelClient" header="true" Title="Clients" autodatabind="true" autoheight="true" runat="server" border="false"  width="400" striperows="true" trackmouseover="true" storeid="clientStore">
            <LoadMask ShowMask="true" Msg="Loading Client Reports..." />
            <AutoLoad AutoDataBind="false" showmask="true" />
            <ColumnModel id="ColumnModel2" runat="server">
                <Columns>
                    <ext:Column ColumnID="ClientName" DataIndex="ClientName" Header="ClientName" Align="Center" Groupable="true" Sortable="true">
                    </ext:Column>
                    <ext:Column ColumnID="DueDate" DataIndex="DueDate" Header="DueDate" Align="Center" Groupable="true" Sortable="true">
                        <Renderer Fn="Ext.util.Format.dateRenderer('m/d/Y')" />
                    </ext:Column>
                    <ext:Column ColumnID="IsActive" DataIndex="IsActive" Header="IsActive" Align="Center" Groupable="true" Sortable="true">
                    </ext:Column>
                    <ext:Column ColumnID="CreatedOn" DataIndex="CreatedOn" Header="CreatedOn" Align="Center" Groupable="true" Sortable="true">
                        <Renderer Fn="Ext.util.Format.dateRenderer('m/d/Y')" />
                    </ext:Column>
                    <ext:Column ColumnID="CreatedBy" DataIndex="CreatedBy" Header="CreatedBy" Align="Center" Groupable="true" Sortable="true">
                    </ext:Column>
                </Columns>
            </ColumnModel>
        </ext:GridPanel>
  2. #2

    RE: 2 GridPanel with Store.reload() locking up browser

    Hi,

    I can't reproduce anything wrong. Reload two grids at once works correctly.
    Please create simple example which can test (or create solution, zip it and post)
    Try to simplify example to narrow the problem
  3. #3

    RE: 2 GridPanel with Store.reload() locking up browser

    Are you using a database to obtain your data? Or are you using array object list as with most examples?
  4. #4

    RE: 2 GridPanel with Store.reload() locking up browser

    Hi,

    I used database.
    I duplicated SqlDataSource/Store/Grid in the following example
    https://examples1.ext.net/#/GridPane...SqlDataSource/

Similar Threads

  1. [CLOSED] [1.2] GridPanel and Store reload scroll position?
    By Timothy in forum 1.x Legacy Premium Help
    Replies: 2
    Last Post: Oct 17, 2011, 5:45 PM
  2. Grouping and locking in a GridPanel
    By sonnh11 in forum 1.x Help
    Replies: 2
    Last Post: Jun 01, 2011, 7:21 AM
  3. [CLOSED] Store Load-handler cant reload child store
    By Jurke in forum 1.x Legacy Premium Help
    Replies: 2
    Last Post: Feb 04, 2011, 7:56 AM
  4. Replies: 1
    Last Post: Dec 24, 2009, 3:36 AM
  5. Databind / Reload Store and GridPanel Problem
    By locoperoguapo in forum 1.x Help
    Replies: 5
    Last Post: Feb 10, 2009, 9:23 AM

Posting Permissions