列入:Tb_AA
code username
1 aaa
2 bbb
3 ccc
创建存储过程
create proc pro_AA
as
begin
set nocount on
select * from Tb_AA
set nocount off
end
---- 执行这个存储过程应该是返回三条记录集现在我用vb去调用
Dim con As New ADODB.Connection
Dim rs2 As New ADODB.Recordset
Dim mycom As New ADODB.Command StrCon = "Provider=SQLOLEDB.1;Password=" & strPassWord & ";Persist Security Info=True;User ID=" & strUserName & ";Initial Catalog="数据库名";Data Source=."
con.CommandTimeout = 3000
con.ConnectionString = StrCon
con.Open
''''''''数据库连接没问题
Set mycom.ActiveConnection = con
mycom.CommandText = "pro_AA"
mycom.CommandType = adCmdStoredProc
Set rs2 = mycom.Execute("pro_AA")
执行到这里 rs2中应该有三条记录集 可是我在程序中得到rs2的记录集为空???????
code username
1 aaa
2 bbb
3 ccc
创建存储过程
create proc pro_AA
as
begin
set nocount on
select * from Tb_AA
set nocount off
end
---- 执行这个存储过程应该是返回三条记录集现在我用vb去调用
Dim con As New ADODB.Connection
Dim rs2 As New ADODB.Recordset
Dim mycom As New ADODB.Command StrCon = "Provider=SQLOLEDB.1;Password=" & strPassWord & ";Persist Security Info=True;User ID=" & strUserName & ";Initial Catalog="数据库名";Data Source=."
con.CommandTimeout = 3000
con.ConnectionString = StrCon
con.Open
''''''''数据库连接没问题
Set mycom.ActiveConnection = con
mycom.CommandText = "pro_AA"
mycom.CommandType = adCmdStoredProc
Set rs2 = mycom.Execute("pro_AA")
执行到这里 rs2中应该有三条记录集 可是我在程序中得到rs2的记录集为空???????
解决方案 »
- 拜求~~EXCEL关于Ranged的Next()与Previous()疑问
- vb调用类模板自定义函数
- 本人要开发一个聊天软件,请QQ里面显示文本的信息是用什么控件的呢
- !!!!!!!!------>>>Method '_Default 'of object 'Sheets' is failed
- 关于vb的命令按钮的一个小问题,
- 有问题but easy
- 请问vb中的dictionary怎样在vc中实现?
- 关于“如何手工将recordset对象绑定到datagrid上”的问题,建议大家进行讨论?
- 如何用VB代码实现SQL Server数据库的备份与恢复!?
- 将计算机屏幕操作的每一步都记录制成动画文件的软件是什么?
- vb窗体隐藏
- 如何 ListView 的卷轴 自动卷到最下面
CON.Open
Dim con As New ADODB.Connection
Dim rs2 As New ADODB.Recordset StrCon = "Provider=SQLOLEDB.1;Password=" & strPassWord & ";Persist Security Info=True;User ID=" & strUserName & ";Initial Catalog="数据库名";Data Source=."
con.CommandTimeout = 3000
con.ConnectionString = StrCon
con.Open
''''''''数据库连接没问题
Set rs2 = con.Execute("exec pro_AA")
pro_AA
看是否有数据?
create proc pro_AA
as
begin
set nocount on
select * from Tb_AA
set nocount off
end
中
set nocount off
不需要
Dim DaCn As New ADODB.Connection
Dim DaRs As New ADODB.Recordset
Dim Sql As String Sql="exec pro_AA"
DaCn.ConnectionString = StrCon
DaCn.Open
DaRs.CursorLocation = adUseClient
DaRs.Open Sql, DaCn, adOpenStatic, adLockReadOnly
if not DaRs then
......
end if
DaRs.Close
DaCn.Close
Set DaRs = Nothing
Set DaCn = Nothing
pro_AA
看是否有数据?若有:
Dim DaCn As New ADODB.Connection
Dim DaRs As New ADODB.Recordset
Dim Sql As String Sql="exec pro_AA"
DaCn.ConnectionString = StrCon
DaCn.CursorLocation = adUseClient
DaCn.open StrCon
DaRs.Open strsql,DaCn,adOpenStatic, adLockReadOnly===用下面的语句看下,DsRs的数据源SQL
debug.print DaRs.Source