最近下载了RadGrid来用,当使用 ExportToExcel() 时,发现无法导出全部数据(只能导出第一页),希望能帮我解答下,谢谢。官方的例子我有试过,使用 DataSourceID 是可以的。代码如下:
<---C#--->
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGrid();
}
} private void BindGrid()
{
DataSet ds = SS();
RadGrid1.DataSource = ds.Tables[0].DefaultView;
RadGrid1.DataBind();
} private DataSet SS()//可正常返回数据
{
.... DataSet DataSet1 = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(SqlCommand);
da.Fill(DataSet1);
return DataSet1;
} protected void ExportButton_Click(object sender, EventArgs e)//导出
{
ConfigureExport();
RadGrid1.MasterTableView.ExportToExcel();
} private void ConfigureExport()
{
RadGrid1.ExportSettings.FileName = HttpUtility.UrlEncode("例子");
RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.IgnorePaging = true;
}
<---C#--->
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGrid();
}
} private void BindGrid()
{
DataSet ds = SS();
RadGrid1.DataSource = ds.Tables[0].DefaultView;
RadGrid1.DataBind();
} private DataSet SS()//可正常返回数据
{
.... DataSet DataSet1 = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(SqlCommand);
da.Fill(DataSet1);
return DataSet1;
} protected void ExportButton_Click(object sender, EventArgs e)//导出
{
ConfigureExport();
RadGrid1.MasterTableView.ExportToExcel();
} private void ConfigureExport()
{
RadGrid1.ExportSettings.FileName = HttpUtility.UrlEncode("例子");
RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.IgnorePaging = true;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货