Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
390
Have a WebDataGrid which keeps timing out
posted

to all - am fairly new to asp.net and infragistics tools - so i am basically forrest gumping my way thru this.  I have a stored procedure (which takes about 2 seconds to run thru SQL Mgt Studio) which returns around 2300 rows of data.  I have a simple datagrid on the main dashboard page which is timing out with the following error:

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

I removed the grid from the page (but left the datasource to execute) and the page loads fine.  so it appears to be a rendering of the grid. 

 

here is the markup for the grid:

 <ig:WebDataGrid  ID="WebDataGrid1"
                                        runat="server"
                                        Width="100%"
                                        AutoGenerateColumns="False"
                                        DataSourceID="rs_OpenOrders"
                                        EnableDataViewState="true"
                                       EnableAjaxViewState="true"
                                        >
                            <Columns>
                                <ig:BoundDataField DataFieldName="OrderNumber" Key="BoundColumn_0"   > 
                                  <Header Text="Order #" />    
                                </ig:BoundDataField>
                                <ig:BoundDataField DataFieldName="CustomerName" Key="BoundColumn_1">
                                    <Header Text="Customer" />
                                </ig:BoundDataField>
                                <ig:BoundDataField DataFieldName="RFQname" Key="BoundColumn_2">
                                    <Header Text="Area" />
                                </ig:BoundDataField>
                                 <ig:BoundDataField DataFieldName="ShipToAddress1" Key="BoundColumn_3">
                                    <Header Text="Ship To Address" />
                                 </ig:BoundDataField>

                         <ig:BoundDataField DataFieldName="ShipToCity" Key="BoundColumn_9">
                                    <Header Text="Ship To City" />
                       </ig:BoundDataField>

                        <ig:BoundDataField DataFieldName="ShipToState" Key="BoundColumn_11">
                                    <Header Text="Ship To State" />
                       </ig:BoundDataField>
  
                        <ig:BoundDataField DataFieldName="FabLoadDate" Key="BoundColumn_10">
                                    <Header Text="Load By Date" />
                       </ig:BoundDataField>
                           
                          
                         
                              <ig:BoundDataField DataFieldName="truckType" Key="BoundColumn_18">
                                    <Header Text="Truck" />
                       </ig:BoundDataField>
                              <ig:BoundDataField DataFieldName="assignedTruck" Key="BoundColumn_19">
                                    <Header Text="Assigned Truck" />
                       </ig:BoundDataField>

                                 <ig:BoundDataField DataFieldName="percentcompleted" Key="BoundColumn_17"  DataFormatString="{0:0.0000}"  >
                                    <Header Text="% Order Fab is complete" />
                       </ig:BoundDataField>
                            
                             <ig:BoundDataField DataFieldName="BarCodeOfBundleCart" Key="BoundColumn_23"    >
                                    <Header Text="Bar Code" />
                       </ig:BoundDataField>

                            


                             <ig:BoundDataField DataFieldName="BundleLocation" Key="BoundColumn_22"    >
                                    <Header Text="bundle location" />
                       </ig:BoundDataField>
                          
                                <ig:TemplateDataField Key="OrderNumber">
                           <ItemTemplate>
                            <asp:HyperLink ID="HyperLink1" runat="server"
                             NavigateUrl='<%#"/bim/ListLocations.aspx?id=" & Eval("ordernumber") %>'
                                            Text="Stage Order"
                                            target="_blank">
                                           
                            </asp:HyperLink>
                           </ItemTemplate>
                          </ig:TemplateDataField>
                       
                          
                               <ig:TemplateDataField Key="assignedTruck">
                           <ItemTemplate>
                            <asp:HyperLink ID="HyperLink1" runat="server"
                             NavigateUrl='<%#"/shipping/load.aspx?id=" & Eval("assignedTruck") %>'
                                            Text="load a truck"
                                           >
                                           
                            </asp:HyperLink>
                           </ItemTemplate>
                          </ig:TemplateDataField>
                       

                        
                          


                             </Columns>
                                 <Behaviors>
                                    <ig:Filtering />
                                    <ig:Sorting />
                                    <ig:Activation />
                                </Behaviors>
                            </ig:WebDataGrid>

 

not sure why the grid will not render.  of course the code works fine in the development evnironment - but it only renders around 100 rows.  any help would be appreciated.

thanks,

e