先以二进制方式打开照片文件,将其读入一个数组,然后用Recordset直接将数组的内容写入图片字段.作者: 徐阿鹏 时间: 2006-8-18 20:42
不会,能否写清楚点,最好有实例!作者: nylgwsf9 时间: 2006-8-21 23:22
在ACCESS的工具箱是有一个叫结合物件框,拖到表单上,然后资料来源选你的图片栏位名称.执行后在该控件是按右键选插入物件,找到图片即可.作者: LeeTien 时间: 2010-4-25 21:36
Dim rs As New ADODB.Recordset//sql 字段是二进制的bmp 连接表显示是ole对象
Dim Istm As ADODB.Stream
rs.Open "SELECT 图片 FROM dbo.图库 WHERE id=" & [Forms]![图库]![id], CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Set Istm = New ADODB.Stream
With Istm
.Mode = adModeReadWrite
.Type = adTypeBinary
.Open
.Write rs("图片")
.SaveToFile "c:\image.jpg"
End With
Me.Image1.Picture = "c:\image.jpg"
rs.Close
Istm.Close
Kill "c:\image.jpg"
Set rs = Nothing
Set Istm = Nothing//请教sql<image>在access的操作作者: LeeTien 时间: 2010-4-25 21:36
Dim rs As New ADODB.Recordset//sql 字段是二进制的bmp 连接表显示是ole对象
Dim Istm As ADODB.Stream
rs.Open "SELECT 图片 FROM dbo.图库 WHERE id=" & [Forms]![图库]![id], CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Set Istm = New ADODB.Stream
With Istm
.Mode = adModeReadWrite
.Type = adTypeBinary
.Open
.Write rs("图片")
.SaveToFile "c:\image.jpg"
End With
Me.Image1.Picture = "c:\image.jpg"
rs.Close
Istm.Close
Kill "c:\image.jpg"
Set rs = Nothing
Set Istm = Nothing//作者: seanfree 时间: 2010-5-20 16:07
先实习一下