Dim rstQ As New ADODB.Recordset
Dim cmdQ As New ADODB.Command
Dim parQ As New ADODB.Parameter
Dim parQ1 As New ADODB.Parameter
Dim parQ2 As New ADODB.Parameter
Dim parQ3 As New ADODB.Parameter
Dim strName As String, strCard As String
If txtName.Text <> "" Then
strName = txtName.Text
Else
strName = "%"
End If
If txtID.Text <> "" Then
strCard = txtID.Text
Else
strCard = "%"
End If
Set cmdQ.ActiveConnection = cnnMain
cmdQ.CommandText = "sp_guestinfo"
cmdQ.CommandType = adCmdStoredProc
parQ.Type = adVarChar
parQ.Direction = adParamInput
parQ.Size = 10
parQ.Value = strName
cmdQ.Parameters.Append parQ
parQ1.Type = adChar
parQ1.Direction = adParamInput
parQ1.Size = 16
parQ1.Value = strCard
cmdQ.Parameters.Append parQ1
parQ2.Type = adDBTimeStamp
parQ2.Direction = adParamInput
parQ2.Size = 10
parQ2.Value = dtpFrom.Value
cmdQ.Parameters.Append parQ2
parQ3.Type = adDBTimeStamp
parQ3.Direction = adParamInput
parQ3.Size = 10
parQ3.Value = dtpTo.Value
cmdQ.Parameters.Append parQ3
Set rstQ = cmdQ.Execute
Set adoGuest.Recordset = rstQ
adoGuest.Refresh
执行到最后一条语句就报错了!但我看到结果已经正确返回来了!
Dim cmdQ As New ADODB.Command
Dim parQ As New ADODB.Parameter
Dim parQ1 As New ADODB.Parameter
Dim parQ2 As New ADODB.Parameter
Dim parQ3 As New ADODB.Parameter
Dim strName As String, strCard As String
If txtName.Text <> "" Then
strName = txtName.Text
Else
strName = "%"
End If
If txtID.Text <> "" Then
strCard = txtID.Text
Else
strCard = "%"
End If
Set cmdQ.ActiveConnection = cnnMain
cmdQ.CommandText = "sp_guestinfo"
cmdQ.CommandType = adCmdStoredProc
parQ.Type = adVarChar
parQ.Direction = adParamInput
parQ.Size = 10
parQ.Value = strName
cmdQ.Parameters.Append parQ
parQ1.Type = adChar
parQ1.Direction = adParamInput
parQ1.Size = 16
parQ1.Value = strCard
cmdQ.Parameters.Append parQ1
parQ2.Type = adDBTimeStamp
parQ2.Direction = adParamInput
parQ2.Size = 10
parQ2.Value = dtpFrom.Value
cmdQ.Parameters.Append parQ2
parQ3.Type = adDBTimeStamp
parQ3.Direction = adParamInput
parQ3.Size = 10
parQ3.Value = dtpTo.Value
cmdQ.Parameters.Append parQ3
Set rstQ = cmdQ.Execute
Set adoGuest.Recordset = rstQ
adoGuest.Refresh
执行到最后一条语句就报错了!但我看到结果已经正确返回来了!
解决方案 »
- VB 正则匹配所有字符
- 使用CreateScalableFontResource等函数安装字体的问题
- 如何在VB下实现应用程序窗口的切换
- 请各位推荐一两本vb的经典书籍 谢谢
- monthview控件的值如何返回给文本框?(text1.text=monthview1.value)触发什么样的事件?即在哪个事件中放置这个代码??谢了!!!
- 如何把DATAGRID文件内容导进文本文件里,而且每个字段的长度是限定的?
- 定位网页 文本框 或者 按钮 ,并用红色框 选中 ,类似我上传的图片 的功能
- 请问:如何把单选内容保存进数据库的表中?
- 关于Picture控件的问题
- 小个关于vb的弱智小问题
- 关于扩展公用对话框的问题!
- 请问什么叫句柄
就可以了,同时要注意设置DataGrid1的Columns与返回字段的匹配,否则在DataGrid1中没有记录显示
报7004错误,the rowset is not bookable
对Rstq的set改为
Rstq.CursorLocation = adUseClient
rstq.Open cmdq, , adOpenDynamic, adLockOptimistic, adCmdStoredProc
Rstq.CursorLocation = adUseClient
Rstq.Open cmdq, , adOpenDynamic, adLockOptimistic, adCmdStoredProc