//DataTable dt = ds.Tables[0];
//HttpContext.Current.Response.Clear();
//int daicount = dt.Rows.Count;
//System.IO.StringWriter sw = new System.IO.StringWriter();
//int iColCount = dt.Columns.Count;
//for (int i = 0;
i < iColCount;
i++)
//{
//sw.Write("/"" + dt.Columns[i] + "/"");
//if (i < iColCount - 1)
//{
//sw.Write(",");
//}
//}
//sw.Write(sw.NewLine);
//foreach (DataRow dr in dt.Rows)
//{
//for (int i = 0;
i < iColCount;
i++)
//{
//if (!Convert.IsDBNull(dr[i]))
//sw.Write("/"" + dr[i].ToString() + "/"");
//else
//sw.Write("/"/"");
//if (i < iColCount - 1)
//{
//sw.Write(",");
//}
//}
//sw.Write(sw.NewLine);
//}
//sw.Close();
//HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;
filename=" + fileName);
//fileName文件名称
//HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
//HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//HttpContext.Current.Response.Write(sw);
【ASP.NET|DataTable直接生成csv文件】//HttpContext.Current.Response.End();
推荐阅读
- Asp.net|System.Globalization.DateTimeFormatInfo.InvariantInfo
- asp.net|c#文件写入与获取post请求数据
- .NET+C#|掌握 ASP.NET 之路(自定义实体类简介(Microsoft))
- .NET+C#|ASP.NET 2.0中Theme、MasterPage和代码国际化
- .NET导出Excel遇到的错误的解决方法
- .net|利用MSXML2.XMLHTTP的无刷新技术
- 快速理解ASP.NET Core的认证与授权
- asp.net|asp.net错误急警
- 工具|调试、部署Oxite 开源系统
- asp.net|在ASP中读取数字证书(ASP.NET)