学步园

using System;<br /> using System.Data;<br /> using System.Configuration;<br /> using System.Collections;<br /> using System.Web;<br /> using System.Web.Security;<br /> using System.Web.UI;<br /> using System.Web.UI.WebControls;<br /> using System.Web.UI.WebControls.WebParts;<br /> using System.Web.UI.HtmlControls;<br /> using System.IO;<br /> namespace AJAXEnabledWebApplication1<br /> {<br /> public partial class excelOutput : System.Web.UI.Page<br /> {<br /> DBClass db = new DBClass();<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> if (!Page.IsPostBack)<br /> {<br /> string strsql = "select * from TreeViewTemp where parentID=0";<br /> DataTable dt = db.GetDataTable(strsql);<br /> this.GridView1.DataSource = dt;<br /> this.GridView1.DataBind();<br /> }<br /> }<br /> protected void Button1_Click(object sender, EventArgs e)<br /> {</p> <p> OutPutExcel();<br /> }</p> <p> //此处要注意,这个重载方法,一定要写,不然会报类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内<br /> public override void VerifyRenderingInServerForm(Control control)<br /> {<br /> }</p> <p> public void OutPutExcel()<br /> {<br /> //定义文档类型、字符编码<br /> Response.Clear();<br /> Response.Buffer = true;<br /> Response.Charset = "GB2312";<br /> //下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开<br /> //filename=FileFlow.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc 　　 .xls 　　 .txt 　　.htm<br /> Response.AppendHeader("Content-Disposition", "attachment;filename=FileFlow.xls");<br /> Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");<br /> //Response.ContentType指定文件类型 可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 或其他浏览器可直接支持文档<br /> Response.ContentType = "application/ms-excel";<br /> this.EnableViewState = false;<br /> //　定义一个输入流<br /> System.IO.StringWriter oStringWriter = new System.IO.StringWriter();<br /> System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);<br /> this.GridView1.RenderControl(oHtmlTextWriter);<br /> //this 表示输出本页，你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件<br /> Response.Write(oStringWriter.ToString());<br /> Response.End();<br /> }</p> <p> }<br /> }<br />