Dim rst As New ADODB.Recordset rst.ActiveConnection = Cn rst.CursorType = adOpenKeyset rst.CursorLocation = adUseClient rst.LockType = adLockReadOnly rst.Source = "SELECT txtfile FROM TABLE" rst.Open Dim mStream As ADODB.Stream Set mStream = New ADODB.Stream mStream.Type = adTypeBinary mStream.Open If Not IsNull(rst.Fields("txtfile")) Then mStream.Write rstImg.Fields("txtfile") mStream.SaveToFile "c:\temp.txt" end if
Option ExplicitDim cn As New ADODB.Connection, rs As New ADODB.Recordset'保存 Private Sub Command1_Click() Dim bteContent() As Byte
Open "C:\aa.bmp" For Binary Access Read As #1 bteContent = InputB(LOF(1), #1) Close #1
If rs.State = adStateOpen Then rs.Close rs.Open "select * from tablename", cn, adOpenDynamic, adLockPessimistic rs.AddNew rs!Name = "张三" rs!AGE = 22 rs!SEX = "男" rs.Fields("PHOTO").AppendChunk bteContent rs.Update
Erase bteContent End Sub'打开 Private Sub Command2_Click() Dim bteContent() As Byte If rs.State = adStateOpen Then rs.Close rs.Open "select * from tablename", cn, adOpenForwardOnly, adLockReadOnly bteContent = rs.Fields("PHOTO").GetChunk(rs.Fields("PHOTO").ActualSize) Open "C:\aa.bmp" For Binary Access Write As #1 Put #1, , bteContent Close #1 End SubPrivate Sub Form_Load() On Error GoTo Errhandle cn.ConnectionString = "Driver={SQL Server};SERVER=DataServer;DATABASE=zxzx;UID=information;PWD=information*&#" cn.Open
Exit Sub Errhandle: MsgBox Err.Description, vbExclamation End SubPrivate Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer) On Error Resume Next rs.Close Set rs = Nothing cn.Close Set cn = Nothing End Sub========================= 这是SQL SERVER 的保存与读取图片,文本也一样,你改一下就可以了!!
只需要将连接代码改成连Oracle就可以吧,你试试
rst.ActiveConnection = Cn
rst.CursorType = adOpenKeyset
rst.CursorLocation = adUseClient
rst.LockType = adLockReadOnly
rst.Source = "SELECT txtfile FROM TABLE"
rst.Open
Dim mStream As ADODB.Stream
Set mStream = New ADODB.Stream
mStream.Type = adTypeBinary
mStream.Open
If Not IsNull(rst.Fields("txtfile")) Then
mStream.Write rstImg.Fields("txtfile")
mStream.SaveToFile "c:\temp.txt"
end if
Private Sub Command1_Click()
Dim bteContent() As Byte
Open "C:\aa.bmp" For Binary Access Read As #1
bteContent = InputB(LOF(1), #1)
Close #1
If rs.State = adStateOpen Then rs.Close
rs.Open "select * from tablename", cn, adOpenDynamic, adLockPessimistic
rs.AddNew
rs!Name = "张三"
rs!AGE = 22
rs!SEX = "男"
rs.Fields("PHOTO").AppendChunk bteContent
rs.Update
Erase bteContent
End Sub'打开
Private Sub Command2_Click()
Dim bteContent() As Byte
If rs.State = adStateOpen Then rs.Close
rs.Open "select * from tablename", cn, adOpenForwardOnly, adLockReadOnly
bteContent = rs.Fields("PHOTO").GetChunk(rs.Fields("PHOTO").ActualSize) Open "C:\aa.bmp" For Binary Access Write As #1
Put #1, , bteContent
Close #1
End SubPrivate Sub Form_Load()
On Error GoTo Errhandle
cn.ConnectionString = "Driver={SQL Server};SERVER=DataServer;DATABASE=zxzx;UID=information;PWD=information*&#"
cn.Open
Exit Sub
Errhandle:
MsgBox Err.Description, vbExclamation
End SubPrivate Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
On Error Resume Next
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub=========================
这是SQL SERVER 的保存与读取图片,文本也一样,你改一下就可以了!!