Private Sub RunSPButton_Click() Dim Qy As New ADODB.Command Dim Parm As New ADODB.Parameter Dim Parm2 As New ADODB.Parameter Dim rs As New ADODB.Recordset Set Qy.ActiveConnection = cn Qy(0)="1947" Qy(1)="1948" Qy.CommandType = adCmdStoredProc Qy.CommandText = "AuthorByYearBorn" Set rs = Qy.Execute(ShowRows) ADOGrid1.ShowData rs End Sub
Dim Qy As New ADODB.Command
Dim Parm As New ADODB.Parameter
Dim Parm2 As New ADODB.Parameter
Dim rs As New ADODB.Recordset Set Qy.ActiveConnection = cn
Qy(0)="1947"
Qy(1)="1948"
Qy.CommandType = adCmdStoredProc
Qy.CommandText = "AuthorByYearBorn" Set rs = Qy.Execute(ShowRows)
ADOGrid1.ShowData rs
End Sub