#18: 数据绑定组件导出数据
View
(Anonymous)
issuedata
Classification:
Feature+Solution
Topic:
Others
Importance:
High
Assigned to:
Created by: sonpater
Created at: 2007-08-17
contact
Name:
吴彬
Description:
实现在绑定后的检索数据的数据能生成其他文件格式,抛给客户端
Solution:
以下提供.NET Web控件中DataGrid控件相关应用的代码(其中dg代表DataGrid时例):
public void setToExcel(string eformsn)
{
// Response.Clear();
// Response.Buffer= true;
// Response.Charset="utf-8";
//attachment 參數表示作為附件下載,您可以改成online在線打開
//filename=FileFlow.xls 指定輸出文件的名稱,注意其擴展名和指定文件類型相符,可以為:.doc .xls .txt .htm
Response.AppendHeader("Content-Disposition","attachment;filename=Report_"+eformsn+".xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");
//Response.ContentType指定文件類型 可以為application/ms-excel,application/ms-word ,application/ms-txt,application/ms-html或其他瀏覽器可直接支持文檔
Response.ContentType = "application/ms-excel";
dg.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
//將目標數據綁定到輸入流輸出
// //this 表示輸出本頁,你也可以綁定datagrid,或其他支持obj.RenderControl()屬性的控件
dg.RenderControl(oHtmlTextWriter);
// this.DataBind.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
Transcript
#1:
2007-08-17 13:47 (sonpater)
topic: "" ->
"Others"
solution: "" ->
"以下提供.NET Web控件中DataGrid控件相关应用的代码(其中dg代表DataGrid时例):
public void setToExcel(string eformsn)
{
// Response.Clear();
// Response.Buffer= true;
// Response.Charset="utf-8";
//attachment 參數表示作為附件下載,您可以改成online在線打開
//filename=FileFlow.xls 指定輸出文件的名稱,注意其擴展名和指定文件類型相符,可以為:.doc .xls .txt .htm
Response.AppendHeader("Content-Disposition","attachment;filename=Report_"+eformsn+".xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");
//Response.ContentType指定文件類型 可以為application/ms-excel,application/ms-word ,application/ms-txt,application/ms-html或其他瀏覽器可直接支持文檔
Response.ContentType = "application/ms-excel";
dg.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
//將目標數據綁定到輸入流輸出
// //this 表示輸出本頁,你也可以綁定datagrid,或其他支持obj.RenderControl()屬性的控件
dg.RenderControl(oHtmlTextWriter);
// this.DataBind.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}"
importance: "medium" ->
"high"
title: "" ->
"数据绑定组件导出数据"
classification: "Bug" ->
"Feature+Solution"
description: "" ->
"实现在绑定后的检索数据的数据能生成其他文件格式,抛给客户端"