一个ado 的例程 可以填到任何地方dim cn as adodb.connection dim ghs as adodb.recordset ............. Set ghs = New ADODB.Recordset Set ghs.ActiveConnection = Cn ghs.Open "select DISTINCT COMPYNAME from jhh" If Not (ghs.BOF And ghs.EOF) Then Do While Not ghs.EOF Me.Combo1.AddItem ghs!compyname ghs.MoveNext Loop End If ghs.Close End Sub
ado:
Dim oRs As New ADODB.Recordset
Dim Cnn as New Adodb.COnnection
Dim oSql As String
cnn.connectstring="......."oSql = "SELECT * FROM Orders "
oRs.Open oSql, cnn
txtDetail(0).Text = oRs("ord_id").Value
dtpDetail(0).Value = oRs("ord_sdate")
lblDetail(8).Caption = oRs("ord_cusname")
txtDetail(2).Text = oRs("ord_writer")
txtDetail(3).Text = oRs("ord_docdate")
txtDetail(4).Text = oRs("ord_re")
cmbDetail.Text = oRs("ord_transport")
Set oRs = Nothing
可以填到任何地方dim cn as adodb.connection
dim ghs as adodb.recordset
.............
Set ghs = New ADODB.Recordset
Set ghs.ActiveConnection = Cn
ghs.Open "select DISTINCT COMPYNAME from jhh"
If Not (ghs.BOF And ghs.EOF) Then
Do While Not ghs.EOF
Me.Combo1.AddItem ghs!compyname
ghs.MoveNext
Loop
End If
ghs.Close
End Sub