using System;
using System.Data;
using System.Data.OleDb;
namespace GRIS.ExcelReprot
{
/// <summary>
/// ImportExportToExcel 的摘要说明。
/// </summary>
public class ImportExportToExcel
{
private string strConn ;
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
//*************************************
public class DataSetToExcel
{
public DataSetToExcel(){}
public void Convert(DataSet oDS,HttpResponse Response)
{
Response.Clear();
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
System.IO.StringWriter oSW = new System.IO.StringWriter();
HtmlTextWriter oHW = new HtmlTextWriter(oSW);
DataGrid oDG = new DataGrid();
oDG.DataSource = oDS.Tables[0];
oDG.DataBind();
oDG.RenderControl(oHW);
Response.Write(oSW.ToString());
Response.Flush();
Response.Close();
}
}
//*********************************************************
調用這個類就OK了