If Rs.State <> adStateClosed Then Rs.Close Rs.Open "select * from Man", Conn, adOpenStatic, adLockOptimistic
For i = 1 To Rs.RecordCount List1.AddItem Rs("Name") Rs.MoveNext Next i
End Sub
dim rs as new adodb.recordset set rs=new adodb.recordset rs.open "select * from [ss]",conn,1,3 if rs.RecordCount<>0 then for i=1 to rs.RecordCount list1.AddItem rs.Fields("邦定字段名") next end if set rs=nothing
dim rs as new adodb.recordset set rs=new adodb.recordset rs.open "select * from [ss]",conn,1,3 set list1.datasource=rs list1.datafield="绑定字段"
Public Conn As New ADODB.ConnectionPrivate Sub Form_Load()
Dim StrConn As String
Dim i As Integer
StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Test.mdb;Persist Security Info=False"
Conn.CursorLocation = adUseClient
Conn.Open StrConn
If Rs.State <> adStateClosed Then Rs.Close
Rs.Open "select * from Man", Conn, adOpenStatic, adLockOptimistic
For i = 1 To Rs.RecordCount
List1.AddItem Rs("Name")
Rs.MoveNext
Next i
End Sub
set rs=new adodb.recordset
rs.open "select * from [ss]",conn,1,3
if rs.RecordCount<>0 then
for i=1 to rs.RecordCount
list1.AddItem rs.Fields("邦定字段名")
next
end if
set rs=nothing
set rs=new adodb.recordset
rs.open "select * from [ss]",conn,1,3
set list1.datasource=rs
list1.datafield="绑定字段"