DATAGRID导入到EXCEL

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;
using System.Data.SqlClient;

namespace DataGridToExcel2
{
 /**//// <summary>
 /// WebForm1 的摘要说明。
 /// </summary>
 public class WebForm1 : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.DataGrid DataGrid1;
  protected System.Web.UI.WebControls.Button Button1;
   
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   if (!IsPostBack)
   {

    SqlConnection conn = new SqlConnection ("data source=200.100.150.4;initial catalog=Northwind;Pwd=;User ID=sa");
    SqlCommand cmd = new SqlCommand ("Select LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region, PostalCode, Country from Employees", conn);
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    da.Fill(ds);
    DataGrid1.DataSource = ds.Tables[0];
    DataGrid1.DataBind();
   }
  }

  //Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
  #region 
  override protected void OnInit(EventArgs e)
   {
    //
    // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
    //
    InitializeComponent();
    base.OnInit(e);
   }
       
  /**//// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.Button1.Click += new System.EventHandler(this.Button1_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  private void Button1_Click(object sender, System.EventArgs e)
  {
   Response.Clear();  
   Response.Buffer=   true;  
   Response.Charset="GB2312";        
   Response.AppendHeader("Content-Disposition","attachment;filename="+System.DateTime .Today.ToShortDateString ()+".xls");  
   Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); //设置输出流为简体中文
   Response.ContentType = "application/ms-excel"; //设置输出文件类型为excel文件。  
   this.EnableViewState = false;        
   System.Globalization.CultureInfo   myCItrad =new System.Globalization.CultureInfo("ZH-CN",true);
   System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);  
   System.Web.UI.HtmlTextWriter   oHtmlTextWriter = new   System.Web.UI.HtmlTextWriter(oStringWriter);
   this.DataGrid1.RenderControl(oHtmlTextWriter);  
   Response.Write(oStringWriter.ToString());
   Response.End();
   
  }
    
 }
}