frmlistfie.frm

来自「教务管理系统,用VB 完成,以SQL SERVER 2000作为后台数据库」· FRM 代码 · 共 66 行

VERSION 5.00
Begin VB.Form FRMLISTFIE 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "数据库字段显示"
   ClientHeight    =   5175
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   2940
   Icon            =   "FRMLISTFIE.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5175
   ScaleWidth      =   2940
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton Command1 
      Caption         =   "返回"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   405
      Left            =   1980
      TabIndex        =   1
      Top             =   4620
      Width           =   795
   End
   Begin VB.ListBox List1 
      Height          =   4380
      Left            =   150
      TabIndex        =   0
      Top             =   90
      Width           =   2625
   End
End
Attribute VB_Name = "FRMLISTFIE"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Unload Me
End Sub

Private Sub Form_Load()
Dim DAT As Database
Dim REC As Recordset
Dim SQL As String
SQL = "SELECT * FROM " & BANJXS & ""
Set DAT = OpenDatabase(App.Path + "\DATABASE\MARK.MDB", , False)
Set REC = DAT.OpenRecordset(SQL, dbOpenDynaset)
Dim I As Integer
Dim N As Integer
For I = 0 To REC.Fields.Count - 1
List1.AddItem REC.Fields(I).Name
Next I

End Sub