简单实用的.net DataTable导出Execl_php教程-查字典教程网
简单实用的.net DataTable导出Execl
简单实用的.net DataTable导出Execl
发布时间:2016-12-29 来源:查字典编辑
摘要:DataTable导出Execl代码太简单,我们直接看代码。复制代码代码如下:protectedvoidbtnPrint_Click(obj...

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 的窗体标记内

}

相关阅读
推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
  • 大家都在看
  • 小编推荐
  • 猜你喜欢
  • 最新php教程学习
    热门php教程学习
    编程开发子分类