asp.net下载CSV代码.
来源:互联网 发布:手机淘宝修改差评链接 编辑:程序博客网 时间:2024/05/23 12:39
imports system.data.oledb
imports system.io
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim connstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source=D:/NTOa/searchemail/db/addr.mdb"
Dim conn As OleDbConnection = New OleDbConnection(connstr)
Dim myad As OleDbDataAdapter = New OleDbDataAdapter("select name,email from address", conn)
myad.Fill(ds, "address")
Dim dt As DataTable
dt = ds.Tables("address")
Dim sw As StringWriter
sw = New StringWriter()
Dim dr As DataRow
sw.WriteLine("姓名,邮件地址")
For Each dr In dt.Rows
sw.WriteLine(dr("name") + "," + dr("email"))
Next
sw.Close()
Response.AddHeader("content-disposition", "attachment;filename=email.csv")
Response.ContentType = "application/ms-excel"
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312")
Response.Write(sw)
Response.End()
End Sub
imports system.io
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim connstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source=D:/NTOa/searchemail/db/addr.mdb"
Dim conn As OleDbConnection = New OleDbConnection(connstr)
Dim myad As OleDbDataAdapter = New OleDbDataAdapter("select name,email from address", conn)
myad.Fill(ds, "address")
Dim dt As DataTable
dt = ds.Tables("address")
Dim sw As StringWriter
sw = New StringWriter()
Dim dr As DataRow
sw.WriteLine("姓名,邮件地址")
For Each dr In dt.Rows
sw.WriteLine(dr("name") + "," + dr("email"))
Next
sw.Close()
Response.AddHeader("content-disposition", "attachment;filename=email.csv")
Response.ContentType = "application/ms-excel"
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312")
Response.Write(sw)
Response.End()
End Sub
- asp.net下载CSV代码.
- ASP.NET下载文件代码
- ASP.NET下载文件代码
- ASP.NET下载文件代码
- 下载CSV文件代码
- asp.net导出CSV
- asp.net读取CSV
- ASP.NET DataGridView 导出CSV文件 后台代码
- asp.net下载文件实现代码
- asp.net 文件下载实现代码
- ASP.NET(C#)下载图片代码
- Asp.net下载功能的解决方案代码
- 下载Excel文件ASP.NET 代码
- asp.net(c#)文件下载实现代码
- asp.net网站下载功能页面代码
- ASP.NET下载文件的代码
- ASP.NET(C#)下载图片代码
- asp.net 操作.CSV文件
- 动态js控件
- 在asp.net x线程
- 测试
- 系统设计原则
- Decompiler Code
- asp.net下载CSV代码.
- 开源物语
- 修改默认远程桌面连接端口
- VB.net 多线程实例
- 发现几个指向自己BLOG的Trackbacks和评论
- java性能优化策略
- 问题:在vs中布局怎么解决?
- 能Ping得通DNS服务器,就是不能上网!
- Just Using Your Imagination.Come On!