Home > php教程 > php手册 > 简单实用的.net DataTable导出Execl

简单实用的.net DataTable导出Execl

WBOY
Release: 2016-06-13 09:31:22
Original
1152 people have browsed it

DataTable导出Execl
代码太简单,我们直接看代码。

复制代码 代码如下:


    protected void btnPrint_Click(object sender, EventArgs e)
    {
        string strPath = "MFOut" + DateTime.Now.ToString("yyyymmddhhmmssfff") + ".xls";
        DataGrid dg = new DataGrid();
        dg.DataSource = dtMain;
        dg.DataBind();
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=" + strPath + "");
        Response.Charset = "gb2312";
        Response.ContentEncoding = System.Text.Encoding.UTF8;//不设置会有乱码
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        dg.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
        //这个方法不能删除掉 导出时要用到,不然会报错:
        //类型“GridView”的控件“ctl00_ContentPlaceHolder1_GridView1”必须放在具有 runat=server 的窗体标记内
    }

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template