如题,急,请高手给段代码示例,谢谢!
解决方案 »
- 区域搜索文件问题
- why.....................................................?
- 关于基础资料开发设计(在线等待)
- 求VB中如何实现添加删除程序的解决办法
- sql数据库,大家帮忙啊,(100分)
- vb打包的问题!3706的错误怎样解决!急等!!!
- 求助高手,遇到难题了...>>>???
- 如何计算两个时间之间相差多少分钟?
- 王国荣的《数据库编程设计》是否适合我学习?在线等待...
- 我编程时常用WinSpy,www.AllApi.net Api Guide,eXescope,各位高手编程时常用那些工具呢?
- 如何动态调用ActiveX Dll?
- Line控件的ToolTipText问题
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open strSQLSERVER
rs.Open "select 字段 from 表名", cn
If Not rs.BOF Then
cbo.Caption = rs("字段")
End If
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub
需要引用SQLDMO(工程/引用/Microsoft SQLDMO Object Library) Dim sqlApp As New SQLDMO.Application()
Dim oServer As New SQLDMO.SQLServer()
oServer.Connect("(local)", "sa", "sa") Dim db As SQLDMO.Database
For Each db In oServer.Databases
Debug.Print db.Name
Next
'工程--->引用--->Microsoft ActiveX Data Object 2.x(版本号)
Private Sub Form_Load()
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
cn.CursorLocation = adUseClient
'连接到master数据库,具体的请自己改过来
cn.Open "Provider=SQLOLEDB.1;Password=;Persist Security Info=False;User ID=sa;Initial Catalog=master;Data Source=ljx"
rs.Open "select [name] from sysdatabases", cn, adOpenDynamic, adLockOptimistic
While Not rs.EOF
Debug.Print rs(0)
rs.MoveNext
Wend
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub