MS Access数据表中的图像存储 [英] image storage in MS Access Data Table

问题描述

如何在MS Access数据表中存储图像。什么是表结构

解决方案

您检查过以下链接吗？



如何存储和查看图像到/从MS访问，C＃ [ ^ ]

http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx [ ^ ]

http://www.jamiessoftware.tk/ articles / handlingimages.html [ ^ ]

尝试以下代码

 Dim cn As ADODB.Connection 
 Set cn = CurrentProject.Connection 
 Dim RS As ADODB.Recordset 
 Dim mstream As ADODB.Stream 
 Dim strQry As String 
 
 strQry =SELECT [picturefieldname] FROM [tablename] WHERE [primaryfieldname] = primaryfieldvalue
 
 Set RS = New ADODB.Recordset 
使用RS 
 .LockType = adLockOptimistic 
 .CursorLocation = adUseClient 
 .CursorType = adOpenDynamic 
。打开strQry，cn 
以
 
结束mstream =新ADODB.Stream 
 mstream.Open 
 mstream.Type = adTypeBinary 
 mstream.LoadFromFile FilePathAndName 
 RS.Fields（PictureFieldName）= mstream.Read 
 RS。更新

How to store an image in MS Access Data Table. and what is the table structure

解决方案

Have you checked the following links?

How to store and view images to/From MS access ,C#[^]
http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx[^]
http://www.jamiessoftware.tk/articles/handlingimages.html[^]

try the following code

Dim cn As ADODB.Connection
Set cn = CurrentProject.Connection
Dim RS As ADODB.Recordset
Dim mstream As ADODB.Stream
Dim strQry As String

strQry="SELECT [picturefieldname] FROM [tablename] WHERE [primaryfieldname]=primaryfieldvalue"

Set RS = New ADODB.Recordset
With RS
   .LockType = adLockOptimistic
   .CursorLocation = adUseClient
   .CursorType = adOpenDynamic
   .Open strQry, cn
End With
    
Set mstream = New ADODB.Stream
mstream.Open
mstream.Type = adTypeBinary
mstream.LoadFromFile FilePathAndName
RS.Fields(PictureFieldName) = mstream.Read
RS.Update

这篇关于MS Access数据表中的图像存储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！