直接存图片代码: Private Sub Command1_Click() On Error GoTo err Dim StmPic As ADODB.Stream '保存你所选择的图像 Set StmPic = New ADODB.Stream StmPic.Type = adTypeBinary '指定流是二进制类型 CommonDialog1.ShowOpen Picture1.Picture = LoadPicture(CommonDialog1.FileName) StmPic.Open '将数据获取到Stream对象中 StmPic.LoadFromFile (CommonDialog1.FileName) '将选择的图像加载到打开的StmPic中 rs.AddNew rs.Fields("pic").Value = StmPic.Read '从StmPic对象中读取数据 rs.Update StmPic.Close Exit Sub err: MsgBox err.Description End SubPrivate Sub Command2_Click() Dim StmPic As ADODB.Stream On Error GoTo err '读取显示数据库中的图像 StrPicTemp="c:\temp.jpeg" Set StmPic = New ADODB.Stream With StmPic .Type = adTypeBinary .Open .Write rs.Fields("pic") '写入数据库中的数据至Stream中 .SaveToFile StrPicTemp, adSaveCreateOverWrite '将Stream中数据写入临时文件中 .Close End With Picture2.Picture = LoadPicture(StrPicTemp) '用Picture控件显示图像 Exit Sub err: MsgBox err.Description End Sub
表.AppendChunk 二进制数组
Private Sub Command1_Click()
On Error GoTo err
Dim StmPic As ADODB.Stream
'保存你所选择的图像
Set StmPic = New ADODB.Stream
StmPic.Type = adTypeBinary '指定流是二进制类型
CommonDialog1.ShowOpen
Picture1.Picture = LoadPicture(CommonDialog1.FileName)
StmPic.Open '将数据获取到Stream对象中
StmPic.LoadFromFile (CommonDialog1.FileName) '将选择的图像加载到打开的StmPic中
rs.AddNew
rs.Fields("pic").Value = StmPic.Read '从StmPic对象中读取数据
rs.Update
StmPic.Close
Exit Sub
err:
MsgBox err.Description
End SubPrivate Sub Command2_Click()
Dim StmPic As ADODB.Stream
On Error GoTo err
'读取显示数据库中的图像
StrPicTemp="c:\temp.jpeg"
Set StmPic = New ADODB.Stream
With StmPic
.Type = adTypeBinary
.Open
.Write rs.Fields("pic") '写入数据库中的数据至Stream中
.SaveToFile StrPicTemp, adSaveCreateOverWrite '将Stream中数据写入临时文件中
.Close
End With
Picture2.Picture = LoadPicture(StrPicTemp) '用Picture控件显示图像
Exit Sub
err:
MsgBox err.Description
End Sub