Hi Guys. I have the next problem.
I have I radgrid declared as follows
I'm using radajaxmanager to update the grid when one of the button columns defined on the grid is pushed.
When one of the button is pushed I show a radConfirm so that the user confirms or cancel the operation.
If user confirms, on RadAjaxManager1_AjaxRequest event I call a stored procedure to perform the update of information, while the proccess is being a radloadingpanel is shown, the problem is that if I execute the SP dicertly through SQL server the proccess takes almost 6 minutes due to the amount of information that is proccessed, but when I execute the store through ajax_request event, the proccess is finished in about 2 minutes.
How can I handle this request time, I try changing executionTimeout on web.config with no success.
Hope your help
Cristian.
I have I radgrid declared as follows
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" CellSpacing="0" GridLines="None" AllowPaging="True" OnNeedDataSource="RadGrid1_NeedDataSource" Skin="WebBlue" OnDeleteCommand="RadGrid1_DeleteCommand" OnInsertCommand="RadGrid1_InsertCommand" OnUpdateCommand="RadGrid1_UpdateCommand" ShowFooter="True" OnItemDataBound="RadGrid1_ItemDataBound" Culture="es-MX" OnItemCommand="RadGrid1_ItemCommand"> <MasterTableView CommandItemSettings-AddNewRecordText="Agregar registro" CommandItemDisplay="None" Caption="Cierre de NĂ³minas" DataKeyNames="fiEjercicio,fiQnaPago" AllowMultiColumnSorting="False" NoMasterRecordsText="No hay registros para mostrar"> <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridNumericColumn DataField="fiEjercicio" DecimalDigits="2" FilterControlAltText="Filter fiEjercicio column" HeaderText="Ejercicio" UniqueName="fiEjercicio"> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="fiQnaPago" DecimalDigits="2" FilterControlAltText="Filter fiQuincena column" HeaderText="Quincena" UniqueName="fiQnaPago"> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="nom_edo" DecimalDigits="2" FilterControlAltText="Filter nom_edo column" HeaderText="Estado" UniqueName="nom_edo"> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="nom_cd" DecimalDigits="2" FilterControlAltText="Filter nom_cd column" HeaderText="Ciudad" UniqueName="nom_cd"> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="expedientes" DecimalDigits="2" FilterControlAltText="Filter expedientes column" HeaderText="# de Servidores PĂºblicos" UniqueName="expedientes"> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="percecpciones" DecimalDigits="2" FilterControlAltText="Filter percecpciones column" HeaderText="Total Percepciones" UniqueName="percecpciones"> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="deducciones" DecimalDigits="2" FilterControlAltText="Filter deducciones column" HeaderText="Total Deducciones" UniqueName="deducciones" > </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="liquido" DecimalDigits="2" FilterControlAltText="Filter liquido column" HeaderText="Total Liquido" UniqueName="liquido"> </telerik:GridNumericColumn> <telerik:GridBoundColumn FilterControlAltText="Filter column column" UniqueName="estatus" HeaderText="Estatus" DataField="fcDescEdo"> </telerik:GridBoundColumn> <telerik:GridBoundColumn FilterControlAltText="Filter column column" UniqueName="estatusCalc" HeaderText="EstatusCalc" Visible="False" DataField="fcDescEdoCalc"> </telerik:GridBoundColumn> <telerik:GridButtonColumn ButtonType="ImageButton" FilterControlAltText="Filter detalle column" HeaderText="Ver Detalle" UniqueName="detalle" CommandName="detalle" ImageUrl="~/_images/iconos/detalle.png"> </telerik:GridButtonColumn> <telerik:GridButtonColumn ButtonType="ImageButton" FilterControlAltText="Filter cierre column" HeaderText="Cierre" UniqueName="cierre" CommandName="cierre" ImageUrl="~/_images/iconos/lock.png"> </telerik:GridButtonColumn> <telerik:GridButtonColumn ButtonType="ImageButton" FilterControlAltText="Filter cierre column" HeaderText="Generar Acumulados" UniqueName="acumulados" CommandName="acumulados" ImageUrl="~/_images/iconos/acumulados.png"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridButtonColumn> </Columns> <EditFormSettings UserControlName="ucEditaCalendario.ascx" EditFormType="WebUserControl"> <EditColumn UniqueName="EditCommandColumn1"> </EditColumn> </EditFormSettings> </MasterTableView> <StatusBarSettings LoadingText="Cargando..." /> <FilterMenu EnableImageSprites="False"> </FilterMenu> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"> </HeaderContextMenu> </telerik:RadGrid>I'm using radajaxmanager to update the grid when one of the button columns defined on the grid is pushed.
When one of the button is pushed I show a radConfirm so that the user confirms or cancel the operation.
If user confirms, on RadAjaxManager1_AjaxRequest event I call a stored procedure to perform the update of information, while the proccess is being a radloadingpanel is shown, the problem is that if I execute the SP dicertly through SQL server the proccess takes almost 6 minutes due to the amount of information that is proccessed, but when I execute the store through ajax_request event, the proccess is finished in about 2 minutes.
How can I handle this request time, I try changing executionTimeout on web.config with no success.
Hope your help
Cristian.