Option ExplicitPrivate Sub 写入数据库_Click() Dim con As New ADODB.Connection Dim rst As New ADODB.Recordset Dim strm As New ADODB.Stream con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False" & _ ";Data Source=D:\study\student.mdb" With strm .Type = adTypeBinary '二进制模式 .Open .LoadFromFile "D:\tmp.jpg" End With
rst.Open "select * from students where stuScore=77", con, adOpenStatic, adLockOptimistic rst.Fields!stuBZ = strm.Read rst.Update rst.Close strm.Close con.Close End SubPrivate Sub 从数据库读_Click() Dim strm As New ADODB.Stream Dim con As New ADODB.Connection Dim rst As New ADODB.Recordset con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False" & _ ";Data Source=D:\study\student.mdb" rst.Open "select * from students where stuScore=77", con, adOpenStatic, adLockOptimistic
strm.Mode = adModeReadWrite strm.Type = adTypeBinary strm.Open strm.Write rst.Fields!stuBZ strm.SaveToFile "d:\huud.jpg" rst.Close strm.Close con.Close End Sub
Dim con As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim strm As New ADODB.Stream
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False" & _
";Data Source=D:\study\student.mdb"
With strm
.Type = adTypeBinary '二进制模式
.Open
.LoadFromFile "D:\tmp.jpg"
End With
rst.Open "select * from students where stuScore=77", con, adOpenStatic, adLockOptimistic
rst.Fields!stuBZ = strm.Read
rst.Update
rst.Close
strm.Close
con.Close
End SubPrivate Sub 从数据库读_Click()
Dim strm As New ADODB.Stream
Dim con As New ADODB.Connection
Dim rst As New ADODB.Recordset
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False" & _
";Data Source=D:\study\student.mdb"
rst.Open "select * from students where stuScore=77", con, adOpenStatic, adLockOptimistic
strm.Mode = adModeReadWrite
strm.Type = adTypeBinary
strm.Open
strm.Write rst.Fields!stuBZ
strm.SaveToFile "d:\huud.jpg"
rst.Close
strm.Close
con.Close
End Sub