01.
<table style=
"width: 100%;"
>
02.
<tr>
03.
<td style=
"width: 50%;"
>
04.
<telerik:RadHtmlChart ID=
"HardCodedMonthNames"
runat=
"server"
DataSourceID=
"SqlDataSourceNearMissByMonth"
>
05.
<ChartTitle Text=
"Near Misses By Month"
>
06.
</ChartTitle>
07.
<Legend>
08.
<Appearance Visible=
"False"
/>
09.
</Legend>
10.
<PlotArea>
11.
<XAxis Visible=
"True"
DataLabelsField=
"Month"
>
12.
<Items>
13.
<telerik:AxisItem LabelText=
"January"
/>
14.
<telerik:AxisItem LabelText=
"February"
/>
15.
<telerik:AxisItem LabelText=
"March"
/>
16.
<telerik:AxisItem LabelText=
"April"
/>
17.
<telerik:AxisItem LabelText=
"May"
/>
18.
<telerik:AxisItem LabelText=
"Jun"
/>
19.
<telerik:AxisItem LabelText=
"July"
/>
20.
<telerik:AxisItem LabelText=
"Aug"
/>
21.
<telerik:AxisItem LabelText=
"September"
/>
22.
<telerik:AxisItem LabelText=
"October"
/>
23.
<telerik:AxisItem LabelText=
"November"
/>
24.
<telerik:AxisItem LabelText=
"December"
/>
25.
</Items>
26.
</XAxis>
27.
28.
<YAxis Visible=
"True"
Name=
"Number of Assessments"
>
29.
<TitleAppearance Position=
"Center"
RotationAngle=
"0"
30.
Text=
"Near Misses"
/>
31.
</YAxis>
32.
33.
<Series>
34.
<telerik:BarSeries DataFieldY=
"Qty"
Name=
"Month"
>
35.
</telerik:BarSeries>
36.
</Series>
37.
</PlotArea>
38.
</telerik:RadHtmlChart>
39.
</td>
40.
<td style=
"width: 50%;"
>
41.
<telerik:RadHtmlChart ID=
"QueryBasedMonthNames"
runat=
"server"
DataSourceID=
"SqlDataSourceNearMissByMonth"
>
42.
<ChartTitle Text=
"Near Misses By Month"
>
43.
</ChartTitle>
44.
<Legend>
45.
<Appearance Visible=
"False"
/>
46.
</Legend>
47.
<PlotArea>
48.
<XAxis Visible=
"True"
DataLabelsField=
"MonthName"
>
49.
50.
</XAxis>
51.
52.
<YAxis Visible=
"True"
Name=
"Number of Assessments"
>
53.
<TitleAppearance Position=
"Center"
RotationAngle=
"0"
54.
Text=
"Near Misses"
/>
55.
</YAxis>
56.
57.
<Series>
58.
<telerik:BarSeries DataFieldY=
"Qty"
Name=
"Month"
>
59.
</telerik:BarSeries>
60.
</Series>
61.
</PlotArea>
62.
</telerik:RadHtmlChart>
63.
64.
</td>
65.
</tr>
66.
</table>
67.
<asp:SqlDataSource ID=
"SqlDataSourceNearMissByMonth"
runat=
"server"
ConnectionString=
"<%$ ConnectionStrings:OSHAConnectionString %>"
SelectCommand="
68.
select
'ABC COMPANY' AS LOCATION,
69.
MONTH,
70.
Year,
71.
DateName( month , DateAdd( month , [MONTH] , 0 ) - 1 ) as MonthName,
72.
COUNT(ID) as Qty
73.
from aaa_v_ReportingData
74.
where IncidentType =
'Near Miss'
75.
and incidentdate is not null
76.
group by Location,
77.
Year,
78.
MONTH,
79.
DateName( month , DateAdd( month , [MONTH] , 0 ) - 1 )
80.
Order by MONTH
81.
">
82.
</asp:SqlDataSource>
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
|
[ArgumentOutOfRangeException: Specified argument was out of the range of valid values. |
dataGrid.ClientSettings.ClientEvents.OnGridCreated = "GridCreated"; |
dataGrid.ClientSettings.ClientEvents.OnRowClick = "RowClick"; |
dataGrid.ClientSettings.ClientEvents.OnCommand = "GridCommand"; |
function RowClick(sender, eventArgs) { |
} |
function GridCommand(sender, args) { |
} |
function GridCreated(sender, eventArgs) { |
} |
Hi
Some of my users need to export to excel a huge quantity of information, 40.000 records or more.
i have two problems
1) The operation takes a lot of time (6 minutes or even more). How can i develop a timeout?
2) In my production server an exception is being triggered. But i cannot reproduce that exception in my development environment, so i don't know where to catch it. Below is a copy of the error i'm getting in the production server.:
========
Exception of type 'System.OutOfMemoryException' was thrown.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.]
System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) +34
System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength) +73
System.Text.StringBuilder.Append(Char value) +97
System.IO.StringWriter.Write(Char value) +28
System.Web.UI.HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag tagKey) +534
System.Web.UI.WebControls.WebControl.RenderBeginTag(HtmlTextWriter writer) +47
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +17
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) +7
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
Telerik.Web.UI.GridTable.RenderContents(HtmlTextWriter writer) +1962
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
Telerik.Web.UI.GridTable.Render(HtmlTextWriter writer) +1802
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) +7
Telerik.Web.UI.GridTableViewBase.Render(HtmlTextWriter writer) +27
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderForm(HtmlTextWriter nullWriter, Control form) +1045
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2065835
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +59
System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +68
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +37
Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderPage(HtmlTextWriter nullWriter, Control page) +102
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2065835
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
System.Web.UI.Page.Render(HtmlTextWriter writer) +26
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
Telerik.Web.UI.RadAjaxControl.RenderPageInAjaxMode(HtmlTextWriter writer, Control page) +619
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2065835
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
System.Web.UI.Page.Render(HtmlTextWriter writer) +26
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1896
===================
I use the method "RadGrid.MasterTableView.ExportToExcel()" , Visual Studio 2005 and RadControls for ASPNET AJAX Q2 2008.
Could you help me with this?