在combobox中如何用ADO对象绑定?
现在想用ADO对象来绑定combobox,假设:
dim cnn1 as ADODB.Connection
dim rs1 as ADODB.Recordset
Private Sub Form_Load()
Set cnn1 = New ADODB.Connection
Set rs1 = New ADODB.Recordset
Dim local_sql As String
cnn1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=发厅综合业务;Data Source=HOME1\SQL2000"
cnn1.Open
local_sql = "select * from 员工信息"
rs1.CursorLocation = adUseClient
rs1.Open local_sql, cnn1, adOpenDynamic, adLockOptimistic
下面我要把ADO对象绑定到combobox1中,应该怎么做?