Dim rs As ADODB.Recordset
Dim sql As String
listallcourse1.Clear
Set rs = New ADODB.Recordset
sql = "select * from table order by ID"
rs.Open sql, conStr, 0, 1
If Not rs.EOF Then
For i = 0 To rs.RecordCount - 1
listallcourse1.AddItem rs.Fields(2)
rs.MoveNext
Next i
End If