Dim Cn As ADODB.Connection
Set Cn = New ADODB.Connection
Dim rs As ADODB.Recordset
Dim strcon As String
strcon = "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=DB;Data Source=192.168.0.100"
Cn.ConnectionString = strcon
On Error Resume Next
Cn.Open
If Cn.State = adStateOpen Then
Set rs = New ADODB.Recordset
Dim sr As String
sr = "select * from product" ' where id =4001"
rs.Open sr, Cn
MsgBox rs.RecordCount
Cn.Close
End If
为什么每次提示的rs.recordcount都=-1阿???怎么解决
Set Cn = New ADODB.Connection
Dim rs As ADODB.Recordset
Dim strcon As String
strcon = "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=DB;Data Source=192.168.0.100"
Cn.ConnectionString = strcon
On Error Resume Next
Cn.Open
If Cn.State = adStateOpen Then
Set rs = New ADODB.Recordset
Dim sr As String
sr = "select * from product" ' where id =4001"
rs.Open sr, Cn
MsgBox rs.RecordCount
Cn.Close
End If
为什么每次提示的rs.recordcount都=-1阿???怎么解决
解决方案 »
- 关于使用Active report 2.0动态添加打印字段的问题
- 求教高手:用vb如何将.swf的flash文件转换成.scr的文件?哪位大虾把源码公开一下啊,拜托了,小弟急用!!
- 怎样用VB实现 在硬盘里搜索一个文件?????????????????????????????????????
- ADO如何修改数据库内容?
- 怎样将MSFlexGrid控件跟ADO控件绑定?
- 关于判断数据类型的的问题?
- 有些软件可以在图片框中显示许多练习题,没次都不一样,怎么实现的啊?
- 急:VB报表程序运行出错!
- 一个聊天器(VB做得),有的机器上可以运行,有的却不行,显示“连接由远程端重新设置”,原代码如下:
- 极菜的一个问题:怎样在字符串中显示 双引号 “
- 高手請進 !winRAR 命令行執行 出錯!
- 关于SQL SERVER自增序号的问题,在线等,问题解决,立刻给分
Rs.CursorLocation = adUseClient
rs.Open sr, Cn, 1, 2
With rs
.Fields("0") = "图"
.Fields("filename") = "4001" & str1 & ".png"
.Fields("updatetime") = Now
.Update
.Close
End With
为什么不能更新了?
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
Dim sr As String
sr = "select title,filename,updatetime from product where id =4001"
rs.Open sr, Cn, adOpenKeyset, adLockBatchOptimistic
With rs
.Fields("title") = "强度图"
.Fields("filename") = "4001" & str1 & ".png"
.Fields("updatetime") = Now
.Update
.Close
End With
rs.CursorLocation = adUseClient
Dim sr As String
sr = "select title,filename,updatetime from product where id =4001"
rs.Open sr, Cn, 1,3
With rs
.Fields("title") = "强度图"
.Fields("filename") = "4001" & str1 & ".png"
.Fields("updatetime") = Now
.Update
.Close
End With
试试看