Set mStmPic = New ADODB.Stream With mStmPic .type = adTypeBinary .Open .LoadFromFile (mStrPicPath) End With Set mRsPic = New ADODB.Recordset mRsPic.Open "select * from img where id='001'", gcnnData, 1, 3 '是否有对应id的纪录,如果有的话就是修改状态,而不是新增数据 If mRsPic.RecordCount = 0 Then mRsPic.AddNew mRsPic.Fields("id") = ReplaceStr$(strBG_NO) End If '如果仅仅是修改数据则不应该修改原有的id号了!!! mRsPic.Fields("photo") = mStmPic.Read mRsPic.Update
下面是读取的代码~~~~~~ ------------------------------------------- '给相片框赋相片文件 Dim mStrPicPath As String Dim mStmPic As ADODB.Stream Dim mRsPic As ADODB.Recordset
Set mRsPic = New ADODB.Recordset mRsPic.Open "select * from img where id='001'", gcnnData, 1, 3 If mRsPic.RecordCount > 0 Then Set mStmPic = New ADODB.Stream With mStmPic .Mode = adModeReadWrite .type = adTypeBinary .Open .Write mRsPic("photo") .SaveToFile mStrPicPath End With End If
Dim mStmPic As ADODB.Stream
Dim mRsPic As ADODB.Recordset
'定义要保存的图片文件
mStrPicPath = App.Path & IIf(Right(App.Path, 1) = "\", "", "\") & "temp\temp.jpg"
Set mStmPic = New ADODB.Stream
With mStmPic
.type = adTypeBinary
.Open
.LoadFromFile (mStrPicPath)
End With Set mRsPic = New ADODB.Recordset
mRsPic.Open "select * from img where id='001'", gcnnData, 1, 3
'是否有对应id的纪录,如果有的话就是修改状态,而不是新增数据
If mRsPic.RecordCount = 0 Then
mRsPic.AddNew
mRsPic.Fields("id") = ReplaceStr$(strBG_NO)
End If
'如果仅仅是修改数据则不应该修改原有的id号了!!!
mRsPic.Fields("photo") = mStmPic.Read
mRsPic.Update
------------------------------------------- '给相片框赋相片文件
Dim mStrPicPath As String
Dim mStmPic As ADODB.Stream
Dim mRsPic As ADODB.Recordset
'定义临时图片文件
mStrPicPath = App.Path & IIf(Right(App.Path, 1) = "\", "", "\") & "temp\temp.jpg"
'清除该文件,目的是为了防止以前的该文件没有删除
Kill mStrPicPath
Set mRsPic = New ADODB.Recordset
mRsPic.Open "select * from img where id='001'", gcnnData, 1, 3
If mRsPic.RecordCount > 0 Then
Set mStmPic = New ADODB.Stream
With mStmPic
.Mode = adModeReadWrite
.type = adTypeBinary
.Open
.Write mRsPic("photo")
.SaveToFile mStrPicPath
End With
End If
imgPro.Picture = LoadPicture(mStrPicPath)----------------------
居然忘了CSDN不能连续恢复超过 3 次,郁闷~~~等有兄弟发言了,再发……… 等待ing……
下回一定要弄个马甲来穿~
(你的软件很好,羡慕...)