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
Hi hlucky,
I noticed there is a duplicate thread - http://www.infragistics.com/community/forums/p/72912/369122.aspx. Please post there any questions you have regarding the matter.