WebGrid是InterSoft公司提供的一款Web表格控件,可以同时在服务器端和客户端进行表格的设置和操作,并且可以把表格数据导出,当表格数据中有1000条数据,每页显示10条数据,如何在数据导出时变为每页4条数据呢?通过在导出数据前改变每页显示的数据,当导出完成后,再改回以前的显示模式即可,具体可以参考下面的代码:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using ISNet.WebUI.WebGrid;
public partial class cs_WebGrid_EnableExporting : System.Web.UI.Page
{
int oldPageSize;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void WebGrid1_ExportCompleted(object sender, ISNet.WebUI.WebGrid.ExportCompletedEventArgs e)
{
WebGrid grid = sender as WebGrid;
grid.LayoutSettings.PagingSize = oldPageSize;
}
protected void WebGrid1_PrepareDataBinding(object sender, DataSourceEventArgs e)
{
WebGrid grid = sender as WebGrid;
if (grid.ActionName == "Export")
{
oldPageSize = grid.LayoutSettings.PagingSize;
int i = grid.GetCurrentPageIndex();
int page = ((i - 1) * oldPageSize / 5)+1;
grid.SetCurrentPageIndex(page);
grid.LayoutSettings.PagingSize = 5;
}
}
}