infragistics webdatagrid 过一段时间后不能显示
我安装了infragistics 2012.2,在aspx中使用了webdatagrid控件,非常好用,实现最简单的增删改查。
发布到IIS7(操作系统:Windows2008 standard server x64)后,一开始能够正常运行,正常显示,能够进行增删改查操作。
但是大约过了20-50分钟(时间不等)过后,再打开这个页面的时候,发现webdatagrid不显示了。但是从网页的源代码中能够看到webdatagrid的数据,使用WebExcelExporter这个控件也能够下载,比较奇怪的就是webdatagrid的界面就是不显示。
需要重启WWW服务、停用应用池、回收应用池等操作(有时要做好多遍),又能恢复正常。
麻烦各位大侠给个提示,谢谢!
系统环境如下:
操作系统:Windows2008 standard server x64
IIS版本:7.0
应用池:.net framework v4.0.30319 集成
源代码如下:
list.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
this.WebDataGrid1.DataSource = this.SqlDataSource1;
if (!this.Page.IsPostBack)
{
this.WebDataGrid1.Dispose();
this.SqlDataSource1.DataBind();
this.WebDataGrid1.DataBind();
this.WebDataGrid1.Visible = true;
}
}
protected void ExportData(object sender, EventArgs e)
{
this.WebExcelExporter1.Export(this.WebDataGrid1);
}
list.aspx
<ig:WebDataGrid ID="WebDataGrid1" runat="server" Height="100%" Width="100%" TabIndex="1" ShowFooter="false" DataKeyFields="idid" AutoGenerateColumns="false" Visible="true">
<Columns>
<ig:BoundDataField DataFieldName="idid" Key="idid" CssClass="ColumnLevelCssClass" Width="50px"><Header Text="ID" CssClass="HeaderCaptionClass" /></ig:BoundDataField>
<ig:BoundDataField DataFieldName="nameid" Key="nameid" CssClass="ColumnLevelCssClass"><Header Text="公司" CssClass="HeaderCaptionClass" /></ig:BoundDataField>
<ig:BoundDataField DataFieldName="carid" Key="carid" CssClass="ColumnLevelCssClass" Width="200px"><Header Text="车牌" CssClass="HeaderCaptionClass" /></ig:BoundDataField>
<ig:BoundDataField DataFieldName="codeid" Key="codeid" CssClass="ColumnLevelCssClass" Width="200px"><Header Text="识别码" CssClass="HeaderCaptionClass" /></ig:BoundDataField>
<ig:BoundDataField DataFieldName="mobileid" Key="mobileid" CssClass="ColumnLevelCssClass" Width="200px"><Header Text="手机" CssClass="HeaderCaptionClass" /></ig:BoundDataField>
<ig:BoundDataField DataFieldName="cardid" Key="cardid" CssClass="ColumnLevelCssClass" Width="200px"><Header Text="身份证" CssClass="HeaderCaptionClass" /></ig:BoundDataField>
<ig:BoundDataField DataFieldName="dateid" Key="dateid" CssClass="ColumnLevelCssClass" Width="100px" DataType="date"><Header Text="日期" CssClass="HeaderCaptionClass" /></ig:BoundDataField>
</Columns>
<Behaviors>
<ig:Activation Enabled="true" ActiveCellCssClass="ActiveCellClass" ActiveRowCssClass="ActiveRowClass"></ig:Activation>
<ig:Selection CellSelectType="Single" CellClickAction="Cell" RowSelectType="Multiple" Enabled="true" SelectionClientEvents-CellSelectionChanged="GetCellValue" SelectedCellCssClass="SelectedCellClass">
<SelectionClientEvents CellSelectionChanged="GetCellValue"></SelectionClientEvents>
</ig:Selection>
<ig:RowSelectors RowNumbering="False" >
</ig:RowSelectors>
<ig:Sorting EnableInheritance="True">
</ig:Sorting>
<ig:Paging PageSize="20" PagerMode="NumericFirstLast">
</ig:Paging>
<ig:EditingCore>
<EditingClientEvents RowsDeleting="WebDataGrid1_Editing_RowsDeleting" />
<EditingClientEvents RowUpdating="" />
<EditingClientEvents RowAdding="WebDataGrid1_Editing_RowAdding" />
<EditingClientEvents CellValueChanging="WebDataGrid1_Editing_CellValueChanging" />
<Behaviors>
<ig:CellEditing Enabled="true">
<EditModeActions MouseClick="Double" />
<ColumnSettings>
<ig:EditingColumnSetting ColumnKey="idid" ReadOnly="true" />
<ig:EditingColumnSetting ColumnKey="nameid" />
<ig:EditingColumnSetting ColumnKey="carid" />
<ig:EditingColumnSetting ColumnKey="codeid" />
<ig:EditingColumnSetting ColumnKey="mobileid" />
<ig:EditingColumnSetting ColumnKey="cardid" />
<ig:EditingColumnSetting ColumnKey="dateid" EditorID="DatePickerProvider1" />
</ColumnSettings>
</ig:CellEditing>
<ig:RowDeleting Enabled="true" />
<ig:RowAdding Alignment="Bottom" AddNewRowClientEvents-EnteringEditMode="eventEnteringAddNewRowEditMode" AddNewRowClientEvents-ExitedEditMode="eventExitedAddNewRowEditMode">
<ColumnSettings>
<ig:RowAddingColumnSetting ColumnKey="idid" ReadOnly="true" />
<ig:RowAddingColumnSetting ColumnKey="nameid" />
<ig:RowAddingColumnSetting ColumnKey="carid" />
<ig:RowAddingColumnSetting ColumnKey="codeid" />
<ig:RowAddingColumnSetting ColumnKey="mobileid" />
<ig:RowAddingColumnSetting ColumnKey="cardid" />
<ig:RowAddingColumnSetting ColumnKey="dateid" EditorID="DatePickerProvider1" />
</ColumnSettings>
</ig:RowAdding>
</Behaviors>
</ig:EditingCore>
<ig:Filtering FilteringClientEvents-EnteringEditMode="eventEnteringFilter" FilteringClientEvents-ExitedEditMode="eventExitedFilter">
</ig:Filtering>
</Behaviors>
<EditorProviders>
<ig:DatePickerProvider ID="DatePickerProvider1" >
<EditorControl ID="EditorControl1" runat="server" ClientIDMode="Predictable" DisplayModeFormat="yyyy-MM-dd" EditModeFormat="yyyy-MM-dd"></EditorControl>
</ig:DatePickerProvider>
</EditorProviders>
</ig:WebDataGrid>
</div>
<asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString="<%$ConnectionStrings:dsn%>"
UpdateCommand="UPDATE [A_Transporter] SET [nameid] = @nameid, [carid] = @carid, [codeid] = @codeid, [mobileid] = @mobileid, [cardid] = @cardid, [dateid] = @dateid WHERE [idid] = @idid"
SelectCommand="select [idid],[nameid],[carid],[codeid],[mobileid],[cardid],[dateid] from [A_Transporter] order by [idid]"
DeleteCommand="DELETE FROM [A_Transporter] WHERE IDID=@idid"
InsertCommand="insert into [A_Transporter] (nameid,carid,codeid,mobileid,cardid,dateid) values (@nameid,@carid,@codeid,@mobileid,@cardid,@dateid)"
>
<UpdateParameters>
<asp:Parameter Name="nameid" Type="String" />
<asp:Parameter Name="carid" Type="String" />
<asp:Parameter Name="codeid" Type="String" />
<asp:Parameter Name="mobileid" Type="String" />
<asp:Parameter Name="cardid" Type="String" />
<asp:Parameter Name="dateid" Type="DateTime" />
<asp:Parameter Name="idid" Type="Int64" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="nameid" Type="String" />
<asp:Parameter Name="carid" Type="String" />
<asp:Parameter Name="codeid" Type="String" />
<asp:Parameter Name="mobileid" Type="String" />
<asp:Parameter Name="cardid" Type="String" />
<asp:Parameter Name="dateid" Type="DateTime" />
</InsertParameters>
</asp:SqlDataSource>
<ig:WebExcelExporter runat="server" ID="WebExcelExporter1"
ExportMode="Download" DownloadName="ExportedData.xls"
DataExportMode="AllDataInDataSource"/>