Set findlist.MSHFlexGrid1.DataSource = rs 提示,“实时错误,要求对象”
时间:2011-11-29
来源:互联网
Private Sub Command1_Click()
MSHFlexGrid1.Cols = 500: MSHFlexGrid1.Rows = 500 '显示多少列多少行
MSHFlexGrid1.Col = 0: MSHFlexGrid1.Row = 0 '从第二行第二列显示
cn.ConnectionString = Str_Ado
cn.Open
rs.CursorLocation = adUseClient
rs.Open "select * from inventory where cinvcode='001'", cn, adOpenKeyset, adLockOptimistic
'like '% " & Trim(find.Text1.Text) & "% ' ", cn, adOpenKeyset, adLockOptimistic
If rs.RecordCount = 0 Then
MsgBox "查无此人! "
Label1.Caption = Str$(0) + "人! "
findlist.MSHFlexGrid1.Clear
Else
Label1.Caption = Str$(rs.RecordCount) + "人! "
Set findlist.MSHFlexGrid1.DataSource = rs
End If
rs.Close
End Sub
'在模组里定义如下变量:
Public cn As New ADODB.Connection '通用连接资料库字串
Public rs As New ADODB.Recordset '通用获取记录集字串
Public Const Str_Ado = "Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User ID=sa;Initial Catalog=ufhr;Data Source=zzh"
Public str_SQL As String '通用SQL查询字串
Public sql As String
Public sql1 As String
Public sql2 As String
Sub Main()
Form1.Show vbModal
End Sub
运行Command1_Click()
时提示,“实时错误,要求对象”,MSHFlexGrid1控件也添加了,Set findlist.MSHFlexGrid1.DataSource = rs 这句话提示
MSHFlexGrid1.Cols = 500: MSHFlexGrid1.Rows = 500 '显示多少列多少行
MSHFlexGrid1.Col = 0: MSHFlexGrid1.Row = 0 '从第二行第二列显示
cn.ConnectionString = Str_Ado
cn.Open
rs.CursorLocation = adUseClient
rs.Open "select * from inventory where cinvcode='001'", cn, adOpenKeyset, adLockOptimistic
'like '% " & Trim(find.Text1.Text) & "% ' ", cn, adOpenKeyset, adLockOptimistic
If rs.RecordCount = 0 Then
MsgBox "查无此人! "
Label1.Caption = Str$(0) + "人! "
findlist.MSHFlexGrid1.Clear
Else
Label1.Caption = Str$(rs.RecordCount) + "人! "
Set findlist.MSHFlexGrid1.DataSource = rs
End If
rs.Close
End Sub
'在模组里定义如下变量:
Public cn As New ADODB.Connection '通用连接资料库字串
Public rs As New ADODB.Recordset '通用获取记录集字串
Public Const Str_Ado = "Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User ID=sa;Initial Catalog=ufhr;Data Source=zzh"
Public str_SQL As String '通用SQL查询字串
Public sql As String
Public sql1 As String
Public sql2 As String
Sub Main()
Form1.Show vbModal
End Sub
运行Command1_Click()
时提示,“实时错误,要求对象”,MSHFlexGrid1控件也添加了,Set findlist.MSHFlexGrid1.DataSource = rs 这句话提示
作者: ZhaoWind 发布时间: 2011-11-29
findlist是什么?
是不是应该这样写:
MSHFlexGrid1.Clear
...
Set MSHFlexGrid1.DataSource = rs
是不是应该这样写:
MSHFlexGrid1.Clear
...
Set MSHFlexGrid1.DataSource = rs
作者: SupermanKing 发布时间: 2011-11-29
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28