📄 frmmap.frm
字号:
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -