资讯中心

用ASP显示ACCESS数据库的GIF图象
  资讯来源:海力源码    发布时间:2022-9-12 17:40:34

写入:

1:把gif图像文件读入内存(一个变量strTemp)。

2:写入数据库。

以下为引用的内容:

Dim binTmp() As Byte

Dim conn As ADODB.Connection

Dim rs As ADODB.Recordset

Dim strSql As String

Set conn = New ADODB.Connection

Set rs = New ADODB.Recordset

conn.Open "db"

strSql = "select * from tbImage"

rs.Open strSql, conn, 1, 3

OpenFile ("bayshore.jpg")

'请自己实现OpenFile函数

rs.AddNew

rs.Fields("image").AppendChunk binTmp

rs.Update

读出和显示:

以下为引用的内容:

http://www.aspku.com/database/access/show.asp:

<%

dim P

dim L

L = 8192

dim conn,rs,strSql

set conn=server.CreateObject("ADODB.Connection")

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &server.MapPath(".") & "db2.mdb;Persist Security Info=False"

set rs=server.CreateObject("ADODB.Recordset")

strSql = "select * from tbImage"

Response.ContentType = "image/gif"

'Important!

rs.open strSql,conn,1,1

rs.movelast

do

P = rs("image").GetChunk(L)

Response.BinaryWrite P

IF LenB(P) < L then exit do

loop

%>

在html中:


上一条:Access中如何用 Jet SQL 语句删除表关系?
下一条:Access为后台数据库的网站统计系统


Copyright www.hailiym.com © 2022