引用Microsoft SQLDMO OBJECT Libraryprivate sub command1_click() onerror goto err1 dim dmoobj as new sqldmo.application dim i as long for i=1 to dmoobj.listavailablesqlservers.count list1.additem dmoobj.listavailablesqlserver.item(i) nexterr1: end sub
不好意思楼上稍微改一下,不过谢谢你的指教 Private Sub command1_click() On Error GoTo err1 Dim dmoobj As New SQLDMO.ApplicationDim i As Long For i = 1 To dmoobj.ListAvailableSQLServers.Count List1.AddItem dmoobj.ListAvailableSQLServers.Item(i) Nexterr1: End Sub
其中有对象可以获取
onerror goto err1
dim dmoobj as new sqldmo.application
dim i as long
for i=1 to dmoobj.listavailablesqlservers.count
list1.additem dmoobj.listavailablesqlserver.item(i)
nexterr1:
end sub
Private Sub command1_click()
On Error GoTo err1
Dim dmoobj As New SQLDMO.ApplicationDim i As Long
For i = 1 To dmoobj.ListAvailableSQLServers.Count
List1.AddItem dmoobj.ListAvailableSQLServers.Item(i)
Nexterr1:
End Sub