asp.net 导出mysql_急!!!在asp.net C#中,怎么将数据库(sql)中的表导出到excel文件里?

先将数据绑定到一个控件中，例如gridview：

放一个按钮，代码如下:

protected void ibtnExcel_Click(object sender, ImageClickEventArgs e)

{

string FileName = "标题 " + DateTime.Now + ".xls";

Response.Charset = "GB2312";

Response.ContentEncoding = Encoding.UTF8;//System.Text

//如果设置GB2312会出现乱码

Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());

Response.AddHeader("content-type", "application / ms - excel");//设置输出文件的类型

//或Response.ContentType = FileType;

//定义一个输出流

StringWriter tw = new StringWriter();//System.IO

HtmlTextWriter hw = new HtmlTextWriter(tw);

gridview1.RenderControl(hw);//gridview绑定

Response.Write(tw.ToString());

Response.End();

}

public override void VerifyRenderingInServerForm(Control control)

{

//必须写这个；

}

取消

评论