Private Conn As ADODB.Connection
Private rs As ADODB.RecordsetPublic Sub Form_Load()Set Conn = New ADODB.Connection
Conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB" & _
".3.51;Data Source=" & App.Path & _
"\ImageLib.mdb"
Conn.Open
Set rs = New ADODB.Recordset
rs.Open "ImageLibrary", Conn, _
adOpenKeyset, adLockPessimistic, adCmdTable
Set imgDBImage.DataSource = rs
imgDBImage.DataField = "ImageBLOB"End Sub
'读 图片
strData = rs("ImageBLOB"). _
GetChunk(rs("ImageBLOB").ActualSize)
Private rs As ADODB.RecordsetPublic Sub Form_Load()Set Conn = New ADODB.Connection
Conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB" & _
".3.51;Data Source=" & App.Path & _
"\ImageLib.mdb"
Conn.Open
Set rs = New ADODB.Recordset
rs.Open "ImageLibrary", Conn, _
adOpenKeyset, adLockPessimistic, adCmdTable
Set imgDBImage.DataSource = rs
imgDBImage.DataField = "ImageBLOB"End Sub
'读 图片
strData = rs("ImageBLOB"). _
GetChunk(rs("ImageBLOB").ActualSize)
解决方案 »
- ?如何使用VB替换Word模版中插入文本框中的文字 和插入图片框中的图片:?
- 简单问题送高分!
- 一个说简单,不简单的问题!关闭别的窗口!
- 程序执行到wordApp.Documents.Add就报错!谁能解答一下!
- 分布式???软件开发问题.....
- ADO查询问题
- vb6、ado、控件datagrid绑定recordset,请问用那种方法可打印datagrid中数据?
- vb 怎么ADO连接一个ORACLE数据库?
- VB中没有web-browse控件
- 冰河4.0原码赠送........
- 请教,如何让DataReport实现横向预览并打印,谢谢!(无内容)
- 谁有给手机发短信息的DLL OR OCX
Private rs As ADODB.RecordsetPublic Sub Form_Load()Set Conn = New ADODB.Connection
Conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB" & _
".3.51;Data Source=" & App.Path & _
"\ImageLib.mdb"
Conn.Open
Set rs = New ADODB.Recordset
rs.Open "ImageLibrary", Conn, _
adOpenKeyset, adLockPessimistic, adCmdTable
Set imgDBImage.DataSource = rs
imgDBImage.DataField = "ImageBLOB"End Sub
'读 图片
strData = rs("ImageBLOB"). _
GetChunk(rs("ImageBLOB").ActualSize)
Dim bytBLOB() As Byte
Dim strImagePath As String
Dim intNum As Integer
'Save the record
strImagePath = Trim$(txtImagePath.Text)
With rs
.Fields("ImageTitle") = _
Trim$(txtImageTitle.Text)
If (optImageType(0).Value) Then
'Save as file pointer
.Fields("ImagePath") = strImagePath
Else
If (txtImagePath.Text <> "") Then
'Open the picture file
intNum = FreeFile
Open strImagePath For Binary As #intNum
ReDim bytBLOB (FileLen(strImagePath))
'Read data and close file
Get #intNum, , bytBLOB
Close #1
'Store the BLOB
.Fields("ImagePath") = ""
.Fields("ImageBLOB"). _
AppendChunk bytBLOB
End If
End If
.Update
End With
End Sub
但是使用Adodc这个VB6新增的控件就比较麻烦,而且在Access数据库中,2000版与早期的版本对图片数据的处理是不一样的,2000版本在图片数据中加了头文件。