代码如下(表1有一个 IMAGE类型的字段"photo"):
'-----------------------------------------------------------------------------
Private Sub Command1_Click()
Dim CN As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim MsStream As New ADODB.Stream
CN.Open "Provider=SQLOLEDB.1链接语句"
RS.Open "SELECT * FROM 表1", CN, adOpenKeyset, adLockOptimistic
MsStream.Type = adTypeBinary
MsStream.Open
MsStream.LoadFromFile "d:\temp.bmp"
RS.AddNew
RS.Fields("photo").Value = MsStream.Read '执行到这一句时出错▲▲▲
RS.Update
RS.Close
CN.Close
End Sub
'---------------------------------------
出错时弹出一个框
“实时错误 '-2147217887 (800400e21)' 发生错误”
'-----------------------------------------------------------------------------
Private Sub Command1_Click()
Dim CN As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim MsStream As New ADODB.Stream
CN.Open "Provider=SQLOLEDB.1链接语句"
RS.Open "SELECT * FROM 表1", CN, adOpenKeyset, adLockOptimistic
MsStream.Type = adTypeBinary
MsStream.Open
MsStream.LoadFromFile "d:\temp.bmp"
RS.AddNew
RS.Fields("photo").Value = MsStream.Read '执行到这一句时出错▲▲▲
RS.Update
RS.Close
CN.Close
End Sub
'---------------------------------------
出错时弹出一个框
“实时错误 '-2147217887 (800400e21)' 发生错误”
解决方案 »
- Request.QueryString接收不到参数!非常急,请各位高手指教。
- 如何设置保存对话框打开时的默认路径
- 谁知道这个错误?
- DataGrid控件为什么不能清空某一行的某一字段的值
- 查询后,再更改记录该怎样写呢?~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- vb打包问题求解
- 如何备份sql server
- 请问Win9x/NT/Me/2000/XP中那些自带了VB6运行库?
- 请问用datagrid控件怎样显示ado连接的数据库?
- 请问各位高手!VB中如何实现带真彩位图的菜单(像NETANT那样)
- 最小化按钮的实现??
- 怎样在vb窗口实现打开google并搜索在vb窗口输入的搜索词 !!!
Dim RS As ADODB.Recordset
Dim MsStream As ADODB.Stream
Set CN =New ADODB.Connection
Set RS =New ADODB.Recordset
Set MsStream =New ADODB.Stream CN.Connectstring=数据库连接字符串
Cn.Open
Dim TxtSQL as String TxtSQL SELECT * FROM 表1
RS.Open "SELECT * FROM 表1", CN, adOpenKeyset, adLockOptimistic
MsStream.Type = adTypeBinary
MsStream.Open
MsStream.LoadFromFile "d:\temp.bmp"
RS.AddNew
RS.Fields("photo").Value = MsStream.Read '执行到这一句时出错▲▲▲
RS.Update
RS.Close
CN.Close
End Sub
Dim RS As ADODB.Recordset
Dim MsStream As ADODB.Stream
Set CN = New ADODB.Connection
Set RS = New ADODB.Recordset
Set MsStream = New ADODB.Stream CN.Connectstring = 数据库连接字符串
CN.Open
Dim TxtSQL As String TxtSQL = "SELECT * FROM 表1"
With RS
.ActiveConnection = CN
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
End With
RS.Open TxtSQL
MsStream.Type = adTypeBinary
MsStream.Mode = adModeReadWrite
MsStream.Open
MsStream.LoadFromFile "d:\temp.bmp"
RS.AddNew
RS.Fields("photo") = MsStream.Read
RS.Update
RS.Close: Set RS = Nothing
MsStream.Close: Set MsStream = Nothing
CN.Close: Set CN = Nothing
End Sub'如果再不行,就找Bell去