DataGrid导出EXCEL的几个方法（WebControl）

DataGird导出EXCEL的几个方法（WebControl）
                                       



using System;
using System.Data;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Diagnostics;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections;


namespace bookstore
{
 /// <summary>
 /// myExcel 的摘要说明。
 /// </summary>
 public class myExcel
 {
  public myExcel()
  {
            
  }

  /// <summary>
  /// 将DATAGRID导出为EXCEL文件方法一,
  /// 参数是:要导出的DATAGRID的ID和要保存下来的EXCEL文件名
  /// </summary>
  /// <param name="myPage">page</param>
  /// <param name="dg">datagrid</param>
  /// <param name="name">filename</param>   
  private void OutExcel(Page myPage,DataGrid dg,string name)
  {
   HttpResponse Response;  
   Response=myPage.Response;  

   string name1="attachment;filename="+name+".xls";  
   dg.Visible=true;
   Response.Clear(); 
   Response.Buffer= true; 
   Response.Charset="GB2312";
   
   Response.AppendHeader("Content-Disposition",name1);   

   Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");   
   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);
   dg.RenderControl(oHtmlTextWriter); 
   Response.Write(oStringWriter.ToString());
   Response.End();
  }