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 + -
显示快捷键?