那3个字段是以什么样的形式显示在combo中呢?是并列还是串在一块呢?
即是field1,field2,field3
还是field1
field2
field3
?若是前者用上面的,后者则用:
With Combo1
.Clear
rst.movefirst
Do While Not rst.EOF
.AddItem rst.fields(0)
.AddItem rst.fields(1)
.AddItem rst.fields(2)
rst.MoveNext
Loop
End With
不用data控件,直接用ado连接,如下:
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=SQLOLEDB;Data Source=servername;User Id=sa;PassWord=****;Initial Catalog=testDB"
'这是将一个字段加入Combo1中(我不明白你是要将3个字段加入一个Combo呢,还是分别加入3个combo?)
rs.Open "select departmentname from departments", cn
With Combo1
.Clear
Do While Not rs.EOF
.AddItem rs!departmentname
rs.MoveNext
Loop
If .ListCount > 0 Then .ListIndex = 0
End With
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing