asp.net导出txt文件

最新推荐文章于 2023-07-06 21:25:53 发布

原创最新推荐文章于 2023-07-06 21:25:53 发布 · 6.5k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #string #object

asp.net 专栏收录该内容

23 篇文章

订阅专栏

本文介绍了一个使用ASP.NET实现的消费明细导出功能。该功能通过查询数据库获取消费记录，并将其格式化为文本形式供用户下载。具体步骤包括：执行SQL查询获取消费数据、将数据绑定到Repeater控件、遍历Repeater项并构造文本字符串、设置HTTP响应头以触发文件下载。

//通过repeater保存为txt文件

protected void btn3_Click(object sender, EventArgs e)
    {
        string sel = "select EX_Parent ,EX_PostCode ,EX_Address  from EnterInfo where EX_Mark like '%" + txtMark3.Text.Trim() + "%'";
        DataTable dt = sqlHelper.ExectueTable(sel);
//取datatable

        rtInfo.DataSource = dt;
        rtInfo.DataBind();
        rtInfo.Visible = true;
        string str = "";

        for (int i = 0; i < this.rtInfo.Items.Count; i++)
        {
            Label labName = (Label)rtInfo.Items[i].FindControl("labName");
            Label labCode = (Label)rtInfo.Items[i].FindControl("labCode");
            Label labAddress = (Label)rtInfo.Items[i].FindControl("labAddress");

            string vv = labName.Text;
            str = str + (vv + ",");
            string vv1 = labCode.Text;
            str = str + (vv1 + ",");
            string vv2 = labAddress.Text;
            str = str + vv2;
            str = str + ("\r\n");
        }

        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        //string val="online;filename=消费明细"+string.Format("{0:yyyyMMddHHmmss}",System.DateTime.Now)+".txt";
        Response.AddHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode("消费明细" + string.Format("{0:yyyyMMddHHmmss}", System.DateTime.Now) + ".txt"));
        //指定返回的是一个不能被客户端读取的流，必须被下载   
        Response.ContentType = "text/plain";
        //把文件流发送到客户端   
        Response.Write(str.ToString());
        //停止页面的执行   
        Response.End();
    }