文章正文

急急急急急急急急急！！！数据库里的image字段下载的问题！！！！请大侠帮忙！！给高分

类型：转载责任编辑：asp 日期：2007/03/01

谁能帮我把下面这段“c#”写的程序，改成用“vb.net”写出来！！谢谢，急用！

string strid;
strid=request.querystring["id"];
int filedatacol = 0;
sqlcommand cmd=new sqlcommand("select filedata,filen from docfujian where id="+strid,myconnection);
myconnection.open();
sqldatareader dr=cmd.executereader();
dr.read();
string filename=server.urlencode(dr.getstring(1));
byte[] b = new byte[(dr.getbytes(filedatacol, 0, null, 0, int.maxvalue))];
dr.getbytes(filedatacol, 0, b, 0, b.length);
dr.close();

myconnection.close();
response.contenttype="application/unknow";
response.addheader("content-disposition","attachment; filename="+filename);
this.response.clear();
system.io.stream fs=this.response.outputstream;
fs.write(b,0,b.length);
fs.close();

this.response.end();
上面这段是image字段通过网页直接下载

推荐阅读

“IT大佬”为何争娶“IT超女”AOL [详细内容]

倪光南拒绝500万？---“入世”冲击我国的IT产业 [详细内容]

原装39电池翻新简述 [详细内容]

解读CPU流行风为PC选时尚“芯”! [详细内容]

中国IT职业培训市场现状及市场前景分析报告 [详细内容]

TCL6898开机不正常 [详细内容]

[上海]三星新款家用投影机震撼登场 [详细内容]

网友回答:

网友：xport

c# 直接转 vb.net, 一一对应转换：
_________________________________________________________________________________
dim strid as string
strid = request.querystring("id")
dim filedatacol as integer = 0
dim cmd as sqlcmd = new sqlcommand("select filedata,filen from docfujian where id=" & strid,myconnection)
myconnection.open()
dim dr as sqldatareader = cmd.executereader()
dr.read()
dim filename as string = server.urlencode(dr.getstring(1));
dim b as byte() = new byte((dr.getbytes(filedatacol, 0, null, 0, int.maxvalue)))
dr.getbytes(filedatacol,0,b,0,b.length)
dr.close()
myconnection.close()
response.contenttype="application/unknow"
response.addheader("content-disposition","attachment; filename="+filename)
me.response.clear()
system.io.stream fs=this.response.outputstream
fs.write(b,0,b.length)
fs.close()
me.response.end()

网友：yuanylong

dim strid as string
strid=request.querystring["id"]
din filedatacol as interger = 0
//myconnection 需要定义
dim cmd as sqlcommand=new sqlcommand("select filedata,filen from docfujian where id="+strid,myconnection)
myconnection.open()
dim dr as sqldatareader
dr=cmd.executereader()
dr.read()
string filename=server.urlencode(dr.getstring(1))
dim b as byte() = new byte((dr.getbytes(filedatacol, 0, null, 0, int.maxvalue)))
dr.getbytes(filedatacol, 0, b, 0, b.length)
dr.close()
myconnection.close()
response.contenttype="application/unknow"
response.addheader("content-disposition","attachment; filename="+filename)
this.response.clear()
dim fs as system.io.stream =this.response.outputstream
fs.write(b,0,b.length)
fs.close()

this.response.end()

网友：arli2003

dim b() as byte = new byte((dr.getbytes(filedatacol, 0, null, 0, int.maxvalue)))

换成

dim b() as byte = dr.getbytes(filedatacol, 0, nothing, 0, int32.maxvalue)

站内导航：

IT热门资讯：