form1.frm

ADO编程模型实例,在VB开发中能用上,可作为参考和借用,节省开发时间

VERSION 5.00
Begin VB.Form Form1 
   Caption         =   "Form1"
   ClientHeight    =   4440
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   3120
   LinkTopic       =   "Form1"
   ScaleHeight     =   4440
   ScaleWidth      =   3120
   StartUpPosition =   3  '窗口缺省
   Begin VB.ComboBox Combo1 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   15.75
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   435
      Left            =   480
      Style           =   2  'Dropdown List
      TabIndex        =   0
      Top             =   360
      Width           =   2295
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'目的：         掌握ADO编程模型
'日期：         2006-5-18
'Programmer:    johnchase
'题目来源：     VBGood论坛
'题目：
'数据库与Combo的连接问题
'
'各位老师请问要怎样做才能把Combo连接到数据库中的某一列， _
 并且在下拉框中把那一列的数据显示出来。

Dim conn As adodb.Connection             '定义一个连接源
Dim rs As adodb.Recordset                 '定义一个记录集
Private Sub form_load()
    Set conn = New adodb.Connection
    Set rs = New adodb.Recordset
    
    conn.Provider = "Microsoft.Jet.OLEDB.4.0"
    conn.ConnectionString = App.Path & "\dbBook.mdb"
    conn.Open
   
    rs.LockType = adLockOptimistic
    rs.CursorType = adOpenKeyset
    Set rs.ActiveConnection = conn
    
    rs.Open "select * from Customers", conn
    If rs.RecordCount > 0 Then
        rs.MoveFirst
        For i = 0 To rs.RecordCount - 1
            Combo1.AddItem rs.Fields("客户姓名")
            rs.MoveNext
        Next i
    End If
    
    rs.Close
    conn.Close
  
End Sub