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.