Option ExplicitPrivate Sub Form_Load()
Form1.AutoRedraw = True
Dim Sc As String, Result As String
Dim Cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim Rs As New ADODB.Recordset
Dim A(5) As String, B(5) As String
Dim i As Integer
i = 0
Sc = "Driver={SQL Server}; Server=(local);Uid=sa;pwd=;database=Employees"
Cn.Open Sc
With cmd
.ActiveConnection = Cn
.CommandType = adCmdStoredProc
.CommandText = "proc_aa"
.Parameters("@T_no") = "2002" '输入参数值
End With
Set Rs = cmd.Execute()
Do While Not Rs.EOF
A(i) = Rs("T_no") '取结果集
B(i) = Rs("Mod") 'T_no和Mod均为表aa中的字段
Rs.MoveNext
i = i + 1
Loop
Rs.Close
Set Rs = Nothing
Set Cn = Nothing
For i = 0 To UBound(A) '显示结果
Print A(i) & " " & B(i)
Next i
End Sub
Form1.AutoRedraw = True
Dim Sc As String, Result As String
Dim Cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim Rs As New ADODB.Recordset
Dim A(5) As String, B(5) As String
Dim i As Integer
i = 0
Sc = "Driver={SQL Server}; Server=(local);Uid=sa;pwd=;database=Employees"
Cn.Open Sc
With cmd
.ActiveConnection = Cn
.CommandType = adCmdStoredProc
.CommandText = "proc_aa"
.Parameters("@T_no") = "2002" '输入参数值
End With
Set Rs = cmd.Execute()
Do While Not Rs.EOF
A(i) = Rs("T_no") '取结果集
B(i) = Rs("Mod") 'T_no和Mod均为表aa中的字段
Rs.MoveNext
i = i + 1
Loop
Rs.Close
Set Rs = Nothing
Set Cn = Nothing
For i = 0 To UBound(A) '显示结果
Print A(i) & " " & B(i)
Next i
End Sub
解决方案 »
- WebBrowser控件问题!
- VB 6.0能写WinCE下的程序吗?
- 让listview同步更新或刷新
- VB+GIS(合作)
- vb调oracle9i存储过程,取输出参数出错问题请教
- winsock 的senddata 发送字节数组的问题,请教各位高手!
- 通过createprocess,waitforsingleobject.这两个函数,在执行外部程序时。如:执行aa.exe在aa.exe程序执行的时候,我拖动它,在主程序里它
- 请问这样的情况下怎样实现sqlserver2000的安全性
- 怎么才能得到一个EXE文件是否在运行呢?我想双击个EXE文件,开始播放声音,当我第二次双击的时候停止播放?怎么实现呢?
- 新手上路,在线请教!!!高分请教excel中的宏问题
- listview空间问题 ? 谢谢大家!
- 如何在vb中找出crystal reports?
CREATE PROCEDURE proc_aa
@T_no char(4)
AS
select T_no, Mod from aa where T_no = @T_no