Oct 08, 2009, 11:11 AM
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?
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" selectonfocus="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>