首页 / 网页编程 / ASP.NET / asp.net实现Gradview绑定数据库数据并导出Excel的方法

本文实例讲述了asp.net实现Gradview绑定数据库数据并导出Excel的方法。分享给大家供大家参考，具体如下：

protected void showData_Click（object sender, EventArgs e）{SqlConnection myConnection = new SqlConnection（"Data Source=localhost;Initial Catalog=test;User ID=sa;password=sa"）;SqlDataAdapter ad = new SqlDataAdapter（"SELECT * FROM booklist", myConnection）;DataSet ds = new DataSet（）;ad.Fill（ds）;this.gvShowData.DataSource = ds;this.gvShowData.DataBind（）;}//导出Excel表protected void btnExportToExcel_Click（object sender, EventArgs e）{Response.Charset = "GB2312";Response.ContentEncoding = System.Text.Encoding.GetEncoding（"GB2312"）;Response.AddHeader（"Content-Type", "application/vnd.ms-excel"）;Response.AddHeader（"Content-Disposition", "myexcelfile.xls"）;//以此编码模式导出才不会出现乱码StringWriter sw = new StringWriter（）;HtmlTextWriter htw = new HtmlTextWriter（sw）;gvShowData.RenderControl（htw）;Response.Write（sw.ToString（））;Response.End（）;}//一定要写，否则出错！！public override void VerifyRenderingInServerForm（Control control）{}

希望本文所述对大家asp.net程序设计有所帮助。