asp.net实现Gradview绑定数据库数据并导出Excel的方法

数据库  /  管理员 发布于 7年前   225

本文实例讲述了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程序设计有所帮助。