★★★★★高分请教,怎样显示SQL中的图形?

SQL2000中可以储存图形。在ASP中怎样把图形在网页上显示出一?
Response.write Recordset.Fields(n).value只能显示文本值呀 ?
请高手帮忙教一下。
---------------------------------------------------------------

sql="select * from images where id="&id
rs.open sql,conn,1,1
if not rs.eof then
set field=rs.fields("image")
img=field.getchunk(265535)'数字按需要调整
Response.BinaryWrite img

---------------------------------------------------------------

1   
2response.Expires = 0   
3response.Buffer = True   
4response.Clear   
5response.contentType = "image/bmp"   
1   
2Const OLEHEADERSIZE = 78   
3nFieldSize = rs("photo").ActualSize   
4oleHeader = rs("photo").GetChunk(OLEHEADERSIZE)   
5imageBytes = rs("photo").GetChunk(nFieldSize - OLEHEADERSIZE)   
6Response.BinaryWrite imageBytes   

---------------------------------------------------------------

showimg.asp文件:

1   
2connGraph.Open   
3set rec=server.createobject("ADODB.recordset")   
4strsql="select img from images where id=" & trim(request("id"))   
5rec.open strsql,connGraph,1,1   
6Response.ContentType = "image/*"   
7Response.BinaryWrite rec("img").getChunk(7500000)   
8rec.close   

在你要显示图片的网页上任何地方加入:

1<img src="showimg.asp?id=xxx"/>

'这里的id指的是你数据库中图片的编号,

Published At
Categories with Web编程
Tagged with
comments powered by Disqus