📄 dataenv.dsr
字号:
Name = "typename"
Caption = "typename"
EndProperty
NumGroups = 0
ParamCount = 1
BeginProperty P1
RealName = "course.typid"
Direction = 1
Precision = 255
Scale = 255
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset7
CommandName = "sqlCourse"
CommDispId = 1444
RsDispId = 1448
CommandText = "select course.serial, course.name, course.period, coursetype.name as typename from course, coursetype "
ActiveConnectionName= "Con"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "serial"
Caption = "serial"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "name"
Caption = "name"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "period"
Caption = "period"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "typename"
Caption = "typename"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset8
CommandName = "sqlStudentScore"
CommDispId = 1450
RsDispId = 1459
CommandText = "select student.serial,student.name, student.class, score.score from student,score where score.studentid=student.serial"
ActiveConnectionName= "Con"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 7
Scale = 0
Type = 202
Name = "serial"
Caption = "serial"
EndProperty
BeginProperty Field2
Precision = 0
Size = 10
Scale = 0
Type = 202
Name = "name"
Caption = "name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "class"
Caption = "class"
EndProperty
BeginProperty Field4
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "score"
Caption = "score"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset9
CommandName = "AddStudent"
CommDispId = 1460
RsDispId = 1463
CommandText = "select serial,name,class from student"
ActiveConnectionName= "Con"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 3
BeginProperty Field1
Precision = 0
Size = 7
Scale = 0
Type = 202
Name = "serial"
Caption = "serial"
EndProperty
BeginProperty Field2
Precision = 0
Size = 10
Scale = 0
Type = 202
Name = "name"
Caption = "name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "class"
Caption = "class"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset10
CommandName = "Course"
CommDispId = 1464
RsDispId = 1469
CommandText = "Course"
ActiveConnectionName= "Con"
CommandType = 2
dbObjectType = 1
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Serial"
Caption = "Serial"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Name"
Caption = "Name"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Period"
Caption = "Period"
EndProperty
BeginProperty Field4
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "typeid"
Caption = "typeid"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset11
CommandName = "Student"
CommDispId = 1470
RsDispId = 1475
CommandText = "Student"
ActiveConnectionName= "Con"
CommandType = 2
dbObjectType = 1
IsRSReturning = -1 'True
NumFields = 8
BeginProperty Field1
Precision = 0
Size = 7
Scale = 0
Type = 202
Name = "Serial"
Caption = "Serial"
EndProperty
BeginProperty Field2
Precision = 0
Size = 10
Scale = 0
Type = 202
Name = "Name"
Caption = "Name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "class"
Caption = "class"
EndProperty
BeginProperty Field4
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "Birthday"
Caption = "Birthday"
EndProperty
BeginProperty Field5
Precision = 0
Size = 2
Scale = 0
Type = 202
Name = "sex"
Caption = "sex"
EndProperty
BeginProperty Field6
Precision = 0
Size = 30
Scale = 0
Type = 202
Name = "Address"
Caption = "Address"
EndProperty
BeginProperty Field7
Precision = 0
Size = 15
Scale = 0
Type = 202
Name = "tel"
Caption = "tel"
EndProperty
BeginProperty Field8
Precision = 0
Size = 536870910
Scale = 0
Type = 203
Name = "resume"
Caption = "resume"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
End
Attribute VB_Name = "DataEnv"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Attribute VB_Ext_KEY = "RVB_ModelStereotype" ,"DataEnvironment"
Private Sub DataEnvironment_Initialize()
''ADO中的数据连接所使用的字段
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Password=;Data Source="
strConn = strConn & App.Path & "\score.mdb" & ";Persist Security Info=True"
Con.ConnectionString = strConn
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -