现在已经可以把图片添加到Image1控件中了,如何把图片写入到数据库呢?
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim stm As New ADODB.Stream
...
stm.Open
stm.Type = adTypeBinary
stm.LoadFromFile CommonDialog1.FileName
rs.AddNew
For i = 0 To 3
rs.Fields(i) = Trim(Text1(i).Text)
Next i
rs.Fields(4) = Str(DTPicker1.Value)
rs.Fields(5) = stm.Read
rs.Update
rs.Close
stm.Close
con.Close
是这样的吗?同样,如何对图片型数据进行查询呢?
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim stm As New ADODB.Stream
...
stm.Open
stm.Type = adTypeBinary
stm.LoadFromFile CommonDialog1.FileName
rs.AddNew
For i = 0 To 3
rs.Fields(i) = Trim(Text1(i).Text)
Next i
rs.Fields(4) = Str(DTPicker1.Value)
rs.Fields(5) = stm.Read
rs.Update
rs.Close
stm.Close
con.Close
是这样的吗?同样,如何对图片型数据进行查询呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货