ASP.NET 中数据读入到文件中并提示下载-优快云博客

本文介绍如何将数据表中的特定列导出为文本文件供用户下载，同时展示了如何将GRIDVIEW中的所有数据导出到Excel文件中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

把数据表中的某一列读入到一个文本文件中并提示下载：

string filename = "data"; Response.Clear(); Response.Buffer = false; Response.ContentType = "application/octet-stream"; Response.AppendHeader("content-disposition", "attachment;filename=" + filename + ".txt;"); string allPhone = string.Empty; DataTable dt = new DataTable(); dt = (DataTable)Session["OUT"]; DataColumn dc = dt.Columns["phone"]; foreach (DataRow r in dt.Rows) { // allPhone += r[dc].ToString() + "<br>"; Response.Write(r[dc].ToString() + "/r/n"); } Response.Flush(); Response.End();

把整个GRIDVIEW的数据读入到excel文件中并提示下载

StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); GridView1.EnableViewState = false; // Deshabilitar la validación de eventos, sólo asp.net 2 page.EnableEventValidation = false; // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD. page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(GridView2); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=data.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End();