http://expert.csdn.net/Expert/topic/2221/2221389.xml?temp=.2510645
解决方案 »
- 请教下局域网连接sql server的问题
- 请问如何做一个有多语言选项的安装包?(多语言选项 安装包 简体 繁体 西班牙语 英语)
- 不想用MSCOMCTM.OCX可以使用ListView吗?
- 如何获得图片上每个像素点的灰度值?
- 爱国者到http://www.1931-9-18.org/bbs/gaspay_sign.asp签名抗日
- 兼职程序员
- 这样的打包报告
- ★★★★CMOS错误,谁能救救我的电脑!!!!★★★★在这里给分,快来呀!★★★★
- 这个''怎么增加的?在线等待!!!
- 请教如何在VB中引用Delphi的ChartFx控件后进行发布
- 如何让LABEL显示在FLASH控件之上
- VB发布打包成功,但是安装时出现错误,请高手指点迷津!
......
Dim cnn1 As ADODB.Connection
Dim cmdByRoyalty As ADODB.Command
Dim prmByRoyalty As ADODB.Parameter
Dim rstByRoyalty As ADODB.Recordset
Dim rstAuthors As ADODB.Recordset
Dim intRoyalty As Integer
Dim strAuthorID As String
Dim strCnn As String Set cnn1 = New ADODB.Connection
strCnn = "Provider=sqloledb;" & _
"Data Source=srv;Initial Catalog=Pubs;User Id=sa;Password=; "
cnn1.Open strCnn
Set cmdByRoyalty = New ADODB.Command
Set cmdByRoyalty.ActiveConnection = cnn1
cmdByRoyalty.CommandText = "byroyalty"
cmdByRoyalty.CommandType = adCmdStoredProc
cmdByRoyalty.CommandTimeout = 15
intRoyalty = Trim(InputBox("Enter royalty:"))
Set prmByRoyalty = New ADODB.Parameter
prmByRoyalty.Type = adInteger
prmByRoyalty.Size = 3
prmByRoyalty.Direction = adParamInput
prmByRoyalty.Value = intRoyalty
cmdByRoyalty.Parameters.Append prmByRoyalty
Set rstByRoyalty = cmdByRoyalty.Execute()
Set rstAuthors = New ADODB.Recordset
Set rstAuthors = datagrid1.DataSource ____ 注意这里!
' rstAuthors.Open "Authors", strCnn, , , adCmdTable
'
' Debug.Print "Authors with " & intRoyalty & _
' " percent royalty"
' Do While Not rstByRoyalty.EOF
' strAuthorID = rstByRoyalty!au_id
' Debug.Print , rstByRoyalty!au_id & ", ";
' rstAuthors.Filter = "au_id = '" & strAuthorID & "'"
' Debug.Print rstAuthors!au_fname & " " & _
' rstAuthors!au_lname
' rstByRoyalty.MoveNext
' Loop
'
' rstByRoyalty.Close
' rstAuthors.Close
' cnn1.Close错误信息:行集合不能作为标签
Set datagrid1.datasource=rstAuthors
但我希望怎样实现VB调用SQL2000的储住过程!