dataenvironment1.dsr

学校田径运动会管理系统是典型的信息管理系统

VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1 
   ClientHeight    =   9885
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   10455
   _ExtentX        =   18441
   _ExtentY        =   17436
   FolderFlags     =   1
   TypeLibGuid     =   "{50B90867-860C-4FCA-9BB8-69715802DC3D}"
   TypeInfoGuid    =   "{41A8CFED-CA83-4DF1-882D-7FCF29E62AEF}"
   TypeInfoCookie  =   0
   Version         =   4
   NumConnections  =   1
   BeginProperty Connection1 
      ConnectionName  =   "Connection1"
      ConnDispId      =   1001
      SourceOfData    =   3
      ConnectionSource=   "Provider=Microsoft.Jet.OLEDB.4.0;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
      Expanded        =   -1  'True
      QuoteChar       =   96
      SeparatorChar   =   46
   EndProperty
   NumRecordsets   =   1
   BeginProperty Recordset1 
      CommandName     =   "Command1"
      CommDispId      =   1002
      RsDispId        =   1023
      CommandText     =   "SELECT 代表队,男子,女子,合计 FROM 代表队统计"
      ActiveConnectionName=   "Connection1"
      CommandType     =   1
      GroupingName    =   "Command1_分组"
      Expanded        =   -1  'True
      IsRSReturning   =   -1  'True
      NumFields       =   4
      BeginProperty Field1 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   202
         Name            =   "代表队"
         Caption         =   "代表队"
      EndProperty
      BeginProperty Field2 
         Precision       =   10
         Size            =   4
         Scale           =   0
         Type            =   3
         Name            =   "男子"
         Caption         =   "男子"
      EndProperty
      BeginProperty Field3 
         Precision       =   10
         Size            =   4
         Scale           =   0
         Type            =   3
         Name            =   "女子"
         Caption         =   "女子"
      EndProperty
      BeginProperty Field4 
         Precision       =   10
         Size            =   4
         Scale           =   0
         Type            =   3
         Name            =   "合计"
         Caption         =   "合计"
      EndProperty
      NumGroups       =   0
      ParamCount      =   0
      RelationCount   =   0
      AggregateCount  =   0
   EndProperty
End
Attribute VB_Name = "DataEnvironment1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub DataEnvironment_Initialize()
Dim cnn As String
Dim mypath As String
mypath = App.Path & "/data"  '获取当前路径
If Right(mypath, 1) <> "/" Then mypath = mypath + "/"
cnn = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & mypath & "db1.mdb" '设置相关数据源
DataEnvironment1.Connection1.ConnectionString = cnn '连接数据库
End Sub