存:
Dim rs As New ADODB.Recordset
Dim Rss As New ADODB.Stream
rs.Open "select * from try", CN, adOpenStatic, adLockOptimistic
Rss.Type = adTypeBinary
Rss.Open
Rss.LoadFromFile App.Path & "\1.jpg"
rs.AddNew
rs.Fields("a1") = Text11.Text
rs.Fields("a2") = Rss.Read
rs.Update
rs.Closea2为ole字段读:
Dim rs As New ADODB.Recordset
Dim Rss As New ADODB.Stream
rs.Open "select * from try", CN
Rss.Type = adTypeBinary
Rss.Open
If Not rs.EOF Then
Rss.Write rs.Fields("a2")
Rss.SaveToFile App.Path & "\tmp.jpg"
Image1.Picture = LoadPicture(App.Path & "\tmp.jpg")
Text2.Text = rs.Fields("a1")
Kill App.Path & "\tmp.jpg"
End If
rs.Close
Dim rs As New ADODB.Recordset
Dim Rss As New ADODB.Stream
rs.Open "select * from try", CN, adOpenStatic, adLockOptimistic
Rss.Type = adTypeBinary
Rss.Open
Rss.LoadFromFile App.Path & "\1.jpg"
rs.AddNew
rs.Fields("a1") = Text11.Text
rs.Fields("a2") = Rss.Read
rs.Update
rs.Closea2为ole字段读:
Dim rs As New ADODB.Recordset
Dim Rss As New ADODB.Stream
rs.Open "select * from try", CN
Rss.Type = adTypeBinary
Rss.Open
If Not rs.EOF Then
Rss.Write rs.Fields("a2")
Rss.SaveToFile App.Path & "\tmp.jpg"
Image1.Picture = LoadPicture(App.Path & "\tmp.jpg")
Text2.Text = rs.Fields("a1")
Kill App.Path & "\tmp.jpg"
End If
rs.Close
解决方案 »
- 求助vb mshflexgrid列与列之间的数据循环问题
- 救急啊!关于MSHFlexGrid绑到空记录集后再绑到有记录的记录集后响应的奇怪问题
- 串口问题!
- 如何读写一个文本文件的指定行
- 如何知道用户是删除、修改还是新增呀
- modem通讯问题,急急!!!!
- 麻烦呀 网页文本框的id,name都一样,怎么办
- [VB6.0]注册表编程方面的问题:读取注册表项指定名称的值的数据
- 怎么插不进去?
- 请问各位高手:使用DATACOMBO控件如何设置才可以做出显示的是字段A的记录,而返回DataSource的是该记录的ID号(或者说是另一个字段B的记录)的效果?谢谢!!!
- 如何创建一个临时表的问题?
- 求助ado中connectinostring的问提
Dim rs As New ADODB.Recordset
Dim Rss As New ADODB.Stream
Dim cnn As ADODB.Connection
Dim cnstr As String
cnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\pic.mdb;Mode=ReadWrite;Persist Security Info=False"
Set cnn = New ADODB.Connection
cnn.Open cnstr
rs.Open "test", cnn, adOpenStatic, adLockOptimistic
Rss.Type = adTypeBinary
Rss.Open
Rss.LoadFromFile App.Path & "\1.jpg"
rs.AddNew
rs.Fields("a1") = "PICTURE"
rs.Fields("a2") = Rss.Read
rs.Update
rs.Close
cnn.Close