12730.html
来自「VB技巧问答10000例,是一个教程」· HTML 代码 · 共 23 行
HTML
23 行
<html>
<head>
<title>Re: 为什么我的List1中无任何选项</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>Re: 为什么我的List1中无任何选项</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:woeioa@ms6.hinet.net">小呆</a> on May 08, 1999 at 14:41:18:<p>
In Reply to: <a href="12724.html">为什么我的List1中无任何选项</a> posted by jeff on May 08, 1999 at 09:33:28:<p>
: 我的Source Code 如下:<p>: <br>: Private Sub Form_Load()<br>: Dim i As Integer<br>: Dim k As Boolean<br>: Dim s As String<br>: <br>: Set dbs = OpenDatabase("c:\s\vbdb.mdb")<br>: Set trade = dbs.OpenRecordset("select 班级资料.班级名称 from 班级资料")<br>: <br>: trade.MoveLast<br>: trade.MoveFirst<br>: 's = "0"<br>: For i = 0 To trade.RecordCount - 1<br>: 'Do Until trade.EOF<br>: <br>: If trade("班级名称") <> 0 Then<br>: <br>: List1.AddItem trade(0)<br>: trade.MoveNext<br>: End If<br>: ' Loop<br>: <br>: Next<br>: trade.Close<br>: <br>: 'List1.ListIndex = -1<br>: 'List2.ListIndex = -1<br>: ' List1.ListIndex = -1<br>: <br>: End Sub<p>: <br>: 我检查过我的资料库中有8笔资料<br>: 但是我的List1中确无任何资料<br>: 应该是下列程式的问题<br>: 可以这样写Program吗?<p>: If trade("班级名称") <> 0 Then<br>: <br>: List1.AddItem trade(0)<br>: trade.MoveNext<br>: 很疑惑<p>=================================================================<br>Private Sub Form_Load()<p>Dim dbs As Database<br>Dim trade As Recordset<p>Set dbs = OpenDatabase("c:\s\vbdb.mdb")<br>Set trade = dbs.OpenRecordset("select 班级资料.班级名称 from 班级资料")<br>List1.Clear<p>Do While trade.EOF = False<br> List1.AddItem trade.班级名称 '新增资料栏。<br> trade.MoveNext '移动到下一个资料栏。<br>Loop<p>trade.Close<br>dbs.Close<br>End Sub<br>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 12730-->
</ul><!--end: 12730-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?