使用VB从dbf表中提取图片数据然后保存为jpg文件
使用下面的程序能够保存成功,但是图片无法显示!
第六个字段为图片数据
哪位高手帮帮忙!Private Sub Command1_Click()
Dim pic() As Byte
Dim conn As New ADODB.Connection
Dim rs As New ADODB.RecordsetPath = App.Path
conn.ConnectionString = "Provider=MSDASQL;Driver=Microsoft Visual Foxpro Driver;SourceType=DBF;SourceDB=" & Path & "\;"
conn.Open
rs.Open "select * from a.dbf", conn, adOpenKeyset And adFldLong, adLockReadOnlyReDim pic(rs(6).ActualSize)
pic = rs(6).Value
Open Path & "\1.jpg" For Binary As #1
Put #1, , pic
Close #1
rs.Close
conn.Close
End Sub
使用下面的程序能够保存成功,但是图片无法显示!
第六个字段为图片数据
哪位高手帮帮忙!Private Sub Command1_Click()
Dim pic() As Byte
Dim conn As New ADODB.Connection
Dim rs As New ADODB.RecordsetPath = App.Path
conn.ConnectionString = "Provider=MSDASQL;Driver=Microsoft Visual Foxpro Driver;SourceType=DBF;SourceDB=" & Path & "\;"
conn.Open
rs.Open "select * from a.dbf", conn, adOpenKeyset And adFldLong, adLockReadOnlyReDim pic(rs(6).ActualSize)
pic = rs(6).Value
Open Path & "\1.jpg" For Binary As #1
Put #1, , pic
Close #1
rs.Close
conn.Close
End Sub
解决方案 »
- 软件设计,求一VB指导老师
- vb 串口通讯的问题
- 如何获得COOKIES文件夹目录
- 请问在ActiveReport中,设置了Printer.PaperSize后,还需要设置PrintWidth吗?
- 关于触发键盘事件的问题
- 哪位老大有Spyworks控件?
- 对文本按关键字进行查找,如何选中含有关键字的名子
- VBA怎样将图片加到Excel指定单元格中
- 为什么不能够同步变动?怎么实现?
- 小草,这个贴子只有你能回答:http://www.csdn.net/Expert/topic/441/441284.shtm
- 怎样才能修改EXE文件标主窗口标题(紧急求助)
- 关于VB6中用Adodc控件确定记录位置的问题
Dim pic() As Byte
Dim conn As New ADODB.Connection
Dim rs As New ADODB.RecordsetPath = App.Path
conn.ConnectionString = "Provider=MSDASQL;Driver=Microsoft Visual Foxpro Driver;SourceType=DBF;SourceDB=" & Path & "\;"
conn.Open
rs.Open "select * from a.dbf", conn, adOpenKeyset And adFldLong, adLockReadOnlyReDim pic(rs(6).ActualSize)
pic = rs(6).GetChunk( rs(6).ActualSize )
Open Path & "\1.jpg" For Binary As #1
Put #1, , pic
Close #1
rs.Close
conn.Close
End Sub
是这样读的,但不能保证保存成功的就一定是正确的图片信息。