如何在SQL Server或Access数据库中存入图片?并用VB调用出来显示?不胜感谢!
解决方案 »
- 怎样去掉webBrowser的边框和水平滚动条?
- VB如何调用VC编写的DLL,DLL的函数中有指针的地址类型
- 有没有方法将VB窗体生成的图像直接存储到Access数据库中
- 在VB代码中如何使用SQL语句模糊查询VF DBF的数据库??
- mshflexgrid能不能在某一列增加combol box列表
- 请问怎样获得WebBrowser控件中的HTML源码
- 如何发布activeX控件?
- 我是一新手,希望大家回答一些我提出的比较菜的问题!
- 这段代码错在哪里
- 关于ado数据控件的问题,请大家帮忙
- sql server 读写表的数据外,还有什么强大的功能?
- 请问如果Datacombo不关联数据库,可不可以像Combobox一样在其中添加任意项?
http://expert.csdn.net/Expert/topic/2487/2487920.xml?temp=.6590387
微软的答案:VB6向SQL SERVER存入图象:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;258038VB.NET向SQL SERVER存入图象:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;308042
http://www.dapha.net/down/list.asp?id=1826
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim stm As ADODB.StreamPrivate Sub SavePictureToDB(cn As ADODB.Connection)
'将BMP图片存入数据库
On Error GoTo EH
Set stm = New ADODB.Stream
rs.Open "select ImagePath,ImageValue from tbl_Image", cn, adOpenKeyset, adLockOptimistic
CommonDialog1.ShowOpen
Text1.Text = CommonDialog1.FileName
With stm
.Type = adTypeBinary
.Open
.LoadFromFile CommonDialog1.FileName
End With
With rs
.AddNew
.Fields("ImagePath") = Text1.Text
.Fields("ImageValue") = stm.Read
.Update
End With
rs.Close
Set rs = Nothing
Exit Sub
EH: MsgBox Err.Description, vbInformation, "Error"
End Sub
Private Sub LoadPictureFromDB(cn As ADODB.Connection)
'载数据库中读出BMP图片
On Error GoTo EH
Dim strTemp As String
Set stm = New ADODB.Stream
strTemp = "c:\temp.tmp" '临时文件,用来保存读出的图片
rs.Open "select ImagePath,ImageValue from tbl_image", cn, , , adCmdText
With stm
.Type = adTypeBinary
.Open
.Write rs("ImageValue")
.SaveToFile strTemp, adSaveCreateOverWrite
.Close
End With
Image1.Picture = LoadPicture(strTemp)
Set stm = Nothing
rs.Close
Set rs = Nothing
Exit Sub
EH: MsgBox Err.Description, vbInformation, "Error"
End Sub