个人工具
Search
Navigation:
Show issue #  

 

#18: 数据绑定组件导出数据

issuedata
Classification: Feature+Solution
Topic: Others
Importance: High
Status: Pending
Assigned to:
Created by: sonpater
Created at: 2007-08-17
contact
Name: 吴彬
Description:
Solution:
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: "" -> "实现在绑定后的检索数据的数据能生成其他文件格式,抛给客户端"