源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

简单实用的.net DataTable导出Execl

  • 时间:2021-01-07 15:19 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:简单实用的.net DataTable导出Execl
DataTable导出Execl 代码太简单,我们直接看代码。
[u]复制代码[/u] 代码如下:
    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 的窗体标记内     }
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部