【VB开源代码栏目提醒】:网学会员为广大网友收集整理了,FrmAdoData.frm,希望对大家有所帮助!
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Begin VB.Form FrmData
BorderStyle = 1 'Fixed Single
Caption = "显示所有员工信息"
ClientHeight = 5460
ClientLeft = 45
ClientTop = 330
ClientWidth = 4920
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5460
ScaleWidth = 4920
StartUpPosition = 2 '屏幕中心
Begin MSAdodcLib.Adodc Adodc1
Height = 375
Left = 773
Top = 120
Width = 3375
_ExtentX = 5953
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 3
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "DSN=newdb"
OLEDBString = ""
OLEDBFile = ""
DataSourceName = "newdb"
OtherAttributes = ""
UserName = "sa"
Pass
word = "sa"
RecordSource = "SELECT * FROM Employee ORDER BY Emp_Id"
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.TextBox Text10
Alignment = 1 'Right Justify
DataField = "Dep_id"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 19
Top = 4800
Width = 3015
End
Begin VB.TextBox Text9
Alignment = 1 'Right Justify
DataField = "Wage"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 17
Top = 4339
Width = 3015
End
Begin VB.TextBox Text8
Alignment = 1 'Right Justify
DataField = "Id_Card"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 15
Top = 3881
Width = 3015
End
Begin VB.TextBox Text7
Alignment = 1 'Right Justify
DataField = "Mobile_phone"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 13
Top = 3423
Width = 3015
End
Begin VB.TextBox Text6
Alignment = 1 'Right Justify
DataField = "Office_phone"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 11
Top = 2965
Width = 3015
End
Begin VB.TextBox Text5
Alignment = 1 'Right Justify
DataField = "Age"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 9
Top = 2507
Width = 3015
End
Begin VB.TextBox Text4
Alignment = 1 'Right Justify
DataField = "Title"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 7
Top = 2049
Width = 3015
End
Begin VB.TextBox Text3
Alignment = 1 'Right Justify
DataField = "Sex"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 5
Top = 1591
Width = 3015
End
Begin VB.TextBox Text2
Alignment = 1 'Right Justify
DataField = "Emp_Name"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 3
Top = 1133
Width = 3015
End
Begin VB.TextBox Text1
Alignment = 1 'Right Justify
DataField = "Emp_Id"
DataSource = "Adodc1"
Height = 270
Left = 1440
TabIndex = 1
Top = 675
Width = 3015
End
Begin VB.Label Label10
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "部门编号:"
Height = 180
Left = 360
TabIndex = 18
Top = 4845
Width = 900
End
Begin
VB.Label Label9
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "工资:"
Height = 180
Left = 360
TabIndex = 16
Top = 4384
Width = 540
End
Begin VB.Label Label8
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "身份证号:"
Height = 180
Left = 360
TabIndex = 14
Top = 3926
Width = 900
End
Begin VB.Label Label7
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "移动电话:"
Height = 180
Left = 360
TabIndex = 12
Top = 3468
Width = 900
End
Begin VB.Label Label6
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "办公电话:"
Height = 180
Left = 360
TabIndex = 10
Top = 3010
Width = 900
End
Begin VB.Label Label5
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "年龄:"
Height = 180
Left = 360
TabIndex = 8
Top = 2552
Width = 540
End
Begin VB.Label Label4
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "职务:"
Height = 180
Left = 360
TabIndex = 6
Top = 2094
Width = 540
End
Begin VB.Label Label3
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "性别:"
Height = 180
Left = 360
TabIndex = 4
Top = 1636
Width = 540
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = ":"
Height = 180
Left = 360
TabIndex = 2
Top = 1178
Width = 540
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "员工编号:"
Height = 180
Left = 360
TabIndex = 0
Top = 720
Width = 900
End
End
Attribute VB_Name = "FrmData"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Adodc1_WillMove(ByVal adR