frmtestsql.frm

利用VB+SQL2000开发的照片管理系统

VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form FrmTestSql 
   ClientHeight    =   945
   ClientLeft      =   45
   ClientTop       =   45
   ClientWidth     =   5025
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   ScaleHeight     =   945
   ScaleWidth      =   5025
   StartUpPosition =   2  'CenterScreen
   Begin VB.Timer Timer2 
      Interval        =   50
      Left            =   2652
      Top             =   96
   End
   Begin VB.Timer Timer1 
      Interval        =   50
      Left            =   1560
      Top             =   144
   End
   Begin MSComCtl2.Animation Animation1 
      Height          =   564
      Left            =   336
      TabIndex        =   0
      Top             =   228
      Width           =   900
      _ExtentX        =   1588
      _ExtentY        =   1005
      _Version        =   393216
      FullWidth       =   60
      FullHeight      =   38
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      Caption         =   "正在连接数据库，请稍等..."
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00800000&
      Height          =   240
      Left            =   1452
      TabIndex        =   1
      Top             =   372
      Width           =   3000
   End
End
Attribute VB_Name = "FrmTestSql"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub Form_Load()
    Call SetWindowPos(Me.hWnd, HWND_TOPMOST, 0, 0, 0, 0, FLAG)
    If Dir(App.Path & "\findcomp.avi") = "" Then
'        MsgBox "文件丢失，请与管理员联系！", vbOKOnly + vbInformation, "文件呢？"
    Else
        Animation1.AutoPlay = True
        Animation1.Open App.Path & "\Findcomp.avi"
    End If
    Timer1.Enabled = False
    Timer2.Enabled = True
End Sub

Private Sub Timer1_Timer()
    Unload Me
End Sub

Private Sub Timer2_Timer()
    Call Server
    Timer2.Enabled = False
End Sub

Private Sub Server()
'判定服务器是否打开
'================================================================================================
    Dim cn As New ADODB.Connection
    On Error GoTo ErrorHandle
    cn.Open DbConnectSql
    cn.Close
    Set cn = Nothing
    ServerIsOpen = True
    Timer1.Enabled = True
    Exit Sub
'================================================================================================
ErrorHandle:
    If Err.Number = -2147467259 Then
'        MsgBox Err.Description, vbOKOnly + vbCritical, "未知错误..."
        Set cn = Nothing
        ServerIsOpen = False
    End If
    Timer1.Enabled = True
End Sub