form1.frm

Visual Basic开发实用编程200例 数据库编程实例

VERSION 5.00
Object = "{65E121D4-0C60-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCHRT20.OCX"
Begin VB.Form Form1 
   Appearance      =   0  'Flat
   BackColor       =   &H80000005&
   Caption         =   "用MSChat图表显示数据(方法一)"
   ClientHeight    =   4800
   ClientLeft      =   1095
   ClientTop       =   825
   ClientWidth     =   10770
   FillStyle       =   2  'Horizontal Line
   BeginProperty Font 
      Name            =   "宋体"
      Size            =   7.5
      Charset         =   134
      Weight          =   400
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   LinkTopic       =   "Form1"
   PaletteMode     =   2  'Custom
   ScaleHeight     =   4800
   ScaleWidth      =   10770
   StartUpPosition =   1  '所有者中心
   Begin VB.CommandButton Command1 
      BackColor       =   &H00E0E0E0&
      Caption         =   "退出"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   510
      Left            =   8145
      Style           =   1  'Graphical
      TabIndex        =   1
      Top             =   4110
      Width           =   2040
   End
   Begin MSChart20Lib.MSChart msChart1 
      Height          =   4155
      Left            =   165
      OleObjectBlob   =   "Form1.frx":0000
      TabIndex        =   0
      Top             =   -45
      Width           =   10635
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private nums As Integer

Private Sub Form_Load()
  Dim db As Database
  Dim rs As Recordset
  Dim dbname As String
  Dim i As Integer
  dbname = App.Path
  If Right$(dbname, 1) <> "\" Then dbname = dbname & "\"       '判断数据库是否在根目录
  dbname = dbname & "data.mdb"
  Set db = OpenDatabase(dbname)                                '打开数据库
  Set rs = db.OpenRecordset("销售表", dbOpenTable)             '打开数据表
  rs.MoveLast
  rs.MoveFirst
  nums = rs.RecordCount
  ReDim arrValues(1 To nums, 1 To 3)                           '定义动态数组
  For i = 1 To nums                                            '给数组赋值
   arrValues(i, 1) = " " & rs!年份
   arrValues(i, 2) = rs!销售额
   arrValues(i, 3) = rs!利润
 rs.MoveNext
 Next i
 msChart1.ChartData = arrValues                               '图表显示数据
 msChart1.Title = "太平洋科技 1988--2002销售额、利润额（单位：万元）图表"   '图表名称
End Sub
Private Sub Command1_Click()
  End
End Sub