frmmap.frm

来自「本软件系统是使用GIS控件MapX在Visual Basic集成开发环境下开发的」· FRM 代码 · 共 157 行

VERSION 5.00
Begin VB.Form frmmap 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "省信息查询"
   ClientHeight    =   2265
   ClientLeft      =   1095
   ClientTop       =   330
   ClientWidth     =   5475
   KeyPreview      =   -1  'True
   LinkTopic       =   "Form3"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2265
   ScaleWidth      =   5475
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton Command1 
      Caption         =   "确定"
      Height          =   435
      Left            =   4110
      TabIndex        =   10
      Top             =   1740
      Width           =   1305
   End
   Begin VB.TextBox txtFields 
      DataField       =   "Population"
      Height          =   285
      Index           =   4
      Left            =   2040
      TabIndex        =   9
      Top             =   1340
      Width           =   3375
   End
   Begin VB.TextBox txtFields 
      DataField       =   "Pinyin_name"
      Height          =   285
      Index           =   3
      Left            =   2040
      TabIndex        =   7
      Top             =   1020
      Width           =   3375
   End
   Begin VB.TextBox txtFields 
      DataField       =   "Guobiao_Admin_Code"
      Height          =   285
      Index           =   2
      Left            =   2040
      TabIndex        =   5
      Top             =   700
      Width           =   3375
   End
   Begin VB.TextBox txtFields 
      DataField       =   "Chinese_ch"
      Height          =   285
      Index           =   1
      Left            =   2040
      TabIndex        =   3
      Top             =   380
      Width           =   3375
   End
   Begin VB.TextBox txtFields 
      DataField       =   "PrcName"
      Height          =   285
      Index           =   0
      Left            =   2040
      TabIndex        =   1
      Top             =   60
      Width           =   3375
   End
   Begin VB.Label lblLabels 
      Alignment       =   1  'Right Justify
      Caption         =   "Population:"
      Height          =   255
      Index           =   4
      Left            =   120
      TabIndex        =   8
      Top             =   1340
      Width           =   1815
   End
   Begin VB.Label lblLabels 
      Alignment       =   1  'Right Justify
      Caption         =   "Pinyin_name:"
      Height          =   255
      Index           =   3
      Left            =   120
      TabIndex        =   6
      Top             =   1020
      Width           =   1815
   End
   Begin VB.Label lblLabels 
      Alignment       =   1  'Right Justify
      Caption         =   "Guobiao_Admin_Code:"
      Height          =   255
      Index           =   2
      Left            =   120
      TabIndex        =   4
      Top             =   700
      Width           =   1815
   End
   Begin VB.Label lblLabels 
      Alignment       =   1  'Right Justify
      Caption         =   "Chinese_ch:"
      Height          =   255
      Index           =   1
      Left            =   120
      TabIndex        =   2
      Top             =   380
      Width           =   1815
   End
   Begin VB.Label lblLabels 
      Alignment       =   1  'Right Justify
      Caption         =   "PrcName:"
      Height          =   255
      Index           =   0
      Left            =   120
      TabIndex        =   0
      Top             =   60
      Width           =   1815
   End
End
Attribute VB_Name = "frmmap"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public PrcName As String

Private Sub Command1_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    Dim db As New ADODB.Connection
    Dim rs As New ADODB.Recordset
    Dim ssql As String
    Dim i As Integer
    
    db.CursorLocation = adUseClient
    
    db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\mdb\map.mdb;"
    
    ssql = "select PrcName,Chinese_ch,Guobiao_Admin_Code," & _
            "Pinyin_name,Population from map where PrcName='" & PrcName & "' Order by PrcName"
    
    rs.Open ssql, db, adOpenForwardOnly
    If rs.RecordCount > 0 Then
        For i = 0 To 4
            txtFields(i).Text = CStr(rs.Fields(i).Value)
        Next
    End If
    rs.Close
    Set rs = Nothing
    
End Sub