下面是在窗体启动时添加组信息到listview中的例子,你可以参照一下Private Sub Form_Load()Dim rsGroup As New ADODB.Recordset'//恢复数据库连接 ResumeCnnFiles'//检索所有组 With rsGroup .CursorLocation = adUseServer .CursorType = adOpenStatic .LockType = adLockPessimistic .Open "SELECT * FROM dictionary WHERE style_id=5", cnnFiles End With'//添加组信息到列表中 Do Until rsGroup.EOF Set itemX = lstvwGroup.ListItems.Add(, "group" & rsGroup("id"), rsGroup("item"), "group", "group") rsGroup.MoveNext LoopEnd Sub
Private Sub Form_Load() sql = "select * from gzlx" Set rs = New ADODB.Recordset rs.Open sql, conn, 3, 3 Do While Not rs.EOF Cbobase.AddItem rs("id") rs.MoveNext LoopEnd Sub
ResumeCnnFiles'//检索所有组
With rsGroup
.CursorLocation = adUseServer
.CursorType = adOpenStatic
.LockType = adLockPessimistic
.Open "SELECT * FROM dictionary WHERE style_id=5", cnnFiles
End With'//添加组信息到列表中
Do Until rsGroup.EOF
Set itemX = lstvwGroup.ListItems.Add(, "group" & rsGroup("id"), rsGroup("item"), "group", "group")
rsGroup.MoveNext
LoopEnd Sub
sql = "select * from gzlx"
Set rs = New ADODB.Recordset
rs.Open sql, conn, 3, 3
Do While Not rs.EOF
Cbobase.AddItem rs("id")
rs.MoveNext
LoopEnd Sub
和ccone1111() !