If PhotoPath = "" Then PhotoPath = App.Path & "\照片\photo.jpg" End If Dim RstStm As ADODB.Stream Set RstStm = New ADODB.Stream Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset RstStm.Type = adTypeBinary Dim sql As String sql = "select photo from zgrsb where zgid=" & Val(LblCode.Caption) RstStm.Open RstStm.LoadFromFile PhotoPath rst.Open sql, CnnToData, adOpenDynamic, adLockOptimistic, adCmdText rst!photo = RstStm.Read rst.Update CnnToData.CommitTrans
PhotoPath = App.Path & "\照片\photo.jpg"
End If
Dim RstStm As ADODB.Stream
Set RstStm = New ADODB.Stream
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
RstStm.Type = adTypeBinary
Dim sql As String
sql = "select photo from zgrsb where zgid=" & Val(LblCode.Caption)
RstStm.Open
RstStm.LoadFromFile PhotoPath
rst.Open sql, CnnToData, adOpenDynamic, adLockOptimistic, adCmdText
rst!photo = RstStm.Read
rst.Update
CnnToData.CommitTrans