asp.net实现Gradview绑定数据库数据并导出Excel的方法
本文实例讲述了asp.net实现Gradview绑定数据库数据并导出Excel的方法。分享给大家供大家参考,具体如下:
protectedvoidshowData_Click(objectsender,EventArgse) { SqlConnectionmyConnection =newSqlConnection("DataSource=localhost;InitialCatalog=test;UserID=sa;password=sa"); SqlDataAdapterad=newSqlDataAdapter("SELECT*FROMbooklist",myConnection); DataSetds=newDataSet(); ad.Fill(ds); this.gvShowData.DataSource=ds; this.gvShowData.DataBind(); } //导出Excel表 protectedvoidbtnExportToExcel_Click(objectsender,EventArgse) { Response.Charset="GB2312"; Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); Response.AddHeader("Content-Type","application/vnd.ms-excel"); Response.AddHeader("Content-Disposition","myexcelfile.xls"); //以此编码模式导出才不会出现乱码 StringWritersw=newStringWriter(); HtmlTextWriterhtw=newHtmlTextWriter(sw); gvShowData.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); } //一定要写,否则出错!! publicoverridevoidVerifyRenderingInServerForm(Controlcontrol) { }
希望本文所述对大家asp.net程序设计有所帮助。