form3.frm

与数据库连接

VERSION 5.00
Object = "{65E121D4-0C60-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCHRT20.OCX"
Begin VB.Form Form3 
   Caption         =   "Form3"
   ClientHeight    =   5040
   ClientLeft      =   2535
   ClientTop       =   2430
   ClientWidth     =   7440
   LinkTopic       =   "Form3"
   ScaleHeight     =   5040
   ScaleWidth      =   7440
   Begin VB.CommandButton Command1 
      Caption         =   "退出"
      Height          =   435
      Left            =   6060
      TabIndex        =   1
      Top             =   4560
      Width           =   1035
   End
   Begin MSChart20Lib.MSChart MSChart1 
      Height          =   4275
      Left            =   60
      OleObjectBlob   =   "Form3.frx":0000
      TabIndex        =   0
      Top             =   60
      Width           =   7395
   End
End
Attribute VB_Name = "Form3"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim Cnxzy As New ADODB.Connection
Dim Rsxzy As New ADODB.Recordset

Private Sub Command1_Click()
Unload Me
Form1.Show
End Sub

Private Sub Form_Load()
   'Dim strQuery As String                                       ' 定义SQL 查询字符串。
    'Set Cnxzy = New Connection
    strcn = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False" & ";Data Source=" + App.Path + "\xzy.mdb"
    Cnxzy.ConnectionString = strcn
    Cnxzy.Open
   
    Rsxzy.Open "SELECT headtemp from getdata", Cnxzy, adOpenKeyset                    ' 打开记录集。
    With MSChart1
       .ShowLegend = True
       Set .DataSource = Rsxzy
       .Title.Text = "          窑头温度            "                               '设置图表名称
       .Title.VtFont.Effect = VtFontEffectUnderline                              '设置下划线
       .Title.VtFont.Size = 10                                                   '设置字体大小
       .Title.VtFont.VtColor.Set 255, 0, 255                                     '设置字体颜色
   End With
End Sub