如何用VB在SQL中存储图片?
解决方案 »
- VB6.0操控Excel文件后,Excel文件不能保存
- 屏蔽图片白色区域的问题?
- 如何取文本内数据
- 请问,如果程序中用到ado,打包是不是要安装这个文件,大家来帮忙啊!
- 为什么我的 webbrowser ,navigate 的时候,如果有书签的话,vb会死掉,说是内存错误
- 帮忙啊!请进!怎样把数据导入到Excel打印并自动换页???◆
- Help!! 如何使一个按钮处于“按下”状态?
- VB生成的dll文件如何被powerbuilder调用?
- vb 里有没有对小数进行 四舍五入 的函数?
- 关于VB监控USB接口打印机的状态的
- 谁有xtreme suite v8.61 for activex专业版的。另开200分相送。
- 怎么用vb打开文件?
'存储照片文件到数据库
Public Function WriteToDB(ByRef col As ADODB.Field, ByVal FileName As String) As Boolean
On Error GoTo ErrMsg
Dim mStream As ADODB.Stream
Set mStream = New ADODB.Stream
WriteToDB = False
mStream.Type = adTypeBinary
mStream.Open
mStream.LoadFromFile FileName
col.Value = mStream.Read
mStream.Close
Set mStream = Nothing
WriteToDB = True
Exit Function
ErrMsg:
MsgBox "存储照片到数据库时出现错误." & vbCrLf & Err.Description, vbExclamation + vbOKOnly, "提示"
End Function'设置临时照片文件
Public Function ReadDB(col As ADODB.Field, ByRef imgFile As String) As Boolean
On Error GoTo ErrRead
Dim mStream As New ADODB.Stream
ReadDB = False
If col.ActualSize < 200 Then Exit Function
mStream.Type = adTypeBinary
mStream.Open
mStream.Write col.Value
mStream.SaveToFile imgFile, adSaveCreateOverWrite
ReadDB = True
Exit Function
ErrRead:
MsgBox "设置临时照片文件时出现错误:" & vbCrLf & Err.Description, vbInformation, "提示"
ReadDB = False
End Function
'
'
把图片写入到数据库
strSQL = "select * from " & strTable _
& " where BBID='" & strBBID & "'" _
& " and ReportIndex=" & objControl.Index _
& " and ReportType=" & WPhoto
Set rsTemp = New ADODB.Recordset
rsTemp.Open strSQL, GCon, adOpenDynamic, adLockOptimistic
WriteToDB rsTemp("ReportPhoto"), mstrTempFile
rsTemp.Update
rsTemp.Close