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程序设计有所帮助。