将数据导出到excle

System.Web.UI.WebControls.DataGrid loggrid=new DataGrid();
string conn="Provider=Microsoft.Jet.oledb.4.0;data source="+Server.MapPath("test.mdb");
OleDbConnection mycon=new OleDbConnection(conn);
string str="select top 6000 * from ZHUANLIB";
DataSet myset=new DataSet();
OleDbDataAdapter myreader=new OleDbDataAdapter(str,mycon);
mycon.Open();
myreader.Fill(myset);
loggrid.DataSource=myset;
loggrid.DataBind();
mycon.Close();

   HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename=Excel.xls");    
   HttpContext.Current.Response.Charset   ="UTF-8";            
   HttpContext.Current.Response.ContentEncoding   =System.Text.Encoding.Default;    
   HttpContext.Current.Response.ContentType   ="application/ms-excel";   
   //loggrid.Page.EnableViewState   =false;          
   System.IO.StringWriter     tw   =   new   System.IO.StringWriter()   ;    
   System.Web.UI.HtmlTextWriter   hw   =   new   System.Web.UI.HtmlTextWriter   (tw);
   loggrid.RenderControl(hw);    
   HttpContext.Current.Response.Write(tw.ToString());    
   HttpContext.Current.Response.End();