something like Dim Qy As New ADODB.Command
Dim Parm As New ADODB.Parameter
Dim Parm2 As New ADODB.Parameter Set Qy.ActiveConnection = cn
Qy(0)="1947"
Qy(1)="1948"
Qy.CommandType = adCmdStoredProc
Qy.CommandText = "AuthorByYearBorn" Set rs = Qy.Execute(ShowRows)
Dim Parm As New ADODB.Parameter
Dim Parm2 As New ADODB.Parameter Set Qy.ActiveConnection = cn
Qy(0)="1947"
Qy(1)="1948"
Qy.CommandType = adCmdStoredProc
Qy.CommandText = "AuthorByYearBorn" Set rs = Qy.Execute(ShowRows)
解决方案 »
- ActiveReport自定义纸张
- 最近开了《高级VISUAL BASIC编程》,发现好多内容看不懂,怎么办?
- fpspread控件的问题:怎么进行全选啊?
- Excel中列宽度的单位是什么?
- 猪陈锐老大生日快乐!:D
- 为什么会提示我“不可识别的数据库格式”呢?
- 我自己做了一个OCX控件想在ASP中用,怎么才能让这个控件是一个安全的控件(IE不提示)
- 什么是组内分布式应用程序
- 请高手帮忙,如何用VB6连接设有密码的access数据库!
- 怎样才能把Combo1下拉框,不能有输入功能.combo1.text的值不能进行修改
- 我在前台的程序中对text1.text=rs!number,为何text1.text的值还是空值,想不通???
- 发邮件
strsql="LT_基础项目_UPDATE (" & CLng(Mid(Frm基础项目管理.lvw管理.SelectedItem.Key, 2)) & "," & Lng分类ID
cn.Execute strsql, , adCmdStoredProc
就这么简单!
Dim strConn As String
Dim cmd As New ADODB.Command
Dim Cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
strConn = "Driver={SQL Server}; Server=(local);Uid=sa;pwd=;database=pubs"
Cn.Open strConn
Set cmd.ActiveConnection = Cn
With cmd
.CommandType = adCmdStoredProc
.CommandText = "byroyalty"
.Parameters("@percentage") = "100"
Set rs = .Execute
End With
Do While Not rs.EOF
Debug.Print rs("au_id")
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
Cn.Close
Set Cn = Nothing