📄 de.dsr
字号:
Size = 0
DataType = 3
HostType = 3
Required = 0 'False
EndProperty
BeginProperty P2
RealName = "@C"
Direction = 1
Precision = 10
Scale = 0
Size = 0
DataType = 3
HostType = 3
Required = -1 'True
EndProperty
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset6
CommandName = "rptFinalResult"
CommDispId = 1031
RsDispId = 1035
CommandText = "dbo.rptFinalResult"
ActiveConnectionName= "Con1"
CallSyntax = "{? = CALL dbo.rptFinalResult( ?, ?) }"
Grouping = -1 'True
GroupingName = "rptFinalResult_Grouping"
SummaryExpanded = -1 'True
IsRSReturning = -1 'True
NumFields = 10
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "stud_id"
Caption = "stud_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "Name"
Caption = "Name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "course_name"
Caption = "course_name"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "father_name"
Caption = "father_name"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Description"
Caption = "Description"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "Exam_name"
Caption = "Exam_name"
EndProperty
BeginProperty Field7
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "sub_name"
Caption = "sub_name"
EndProperty
BeginProperty Field8
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Score"
Caption = "Score"
EndProperty
BeginProperty Field9
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Grade"
Caption = "Grade"
EndProperty
BeginProperty Field10
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "sem"
Caption = "sem"
EndProperty
NumGroups = 5
BeginProperty Grouping1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "stud_id"
Caption = "stud_id"
EndProperty
BeginProperty Grouping2
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "Name"
Caption = "Name"
EndProperty
BeginProperty Grouping3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "course_name"
Caption = "course_name"
EndProperty
BeginProperty Grouping4
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "father_name"
Caption = "father_name"
EndProperty
BeginProperty Grouping5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Description"
Caption = "Description"
EndProperty
ParamCount = 3
BeginProperty P1
RealName = "@RETURN_VALUE"
Direction = 4
Precision = 10
Scale = 0
Size = 0
DataType = 3
HostType = 3
Required = 0 'False
EndProperty
BeginProperty P2
RealName = "@studentID"
Direction = 1
Precision = 10
Scale = 0
Size = 0
DataType = 3
HostType = 3
Required = -1 'True
EndProperty
BeginProperty P3
RealName = "@examID"
Direction = 1
Precision = 10
Scale = 0
Size = 0
DataType = 3
HostType = 3
Required = -1 'True
EndProperty
RelationCount = 0
AggregateCount = 1
BeginProperty Aggregate1
Name = "SumOfScore"
AggOn = "rptFinalResult"
AggField = "Score"
AggType = 2
AggFunction = 7
Precision = 8
Size = 4
Scale = 8
Type = 131
Name = "SumOfScore"
Caption = "SumOfScore"
Control = "TextBox"
ControlGuid = "{0CA5C786-7C71-11D0-B223-00A0C908FB55}"
EndProperty
EndProperty
BeginProperty Recordset7
CommandName = "rptallcourse"
CommDispId = 1036
RsDispId = 1047
CommandText = "select * from course"
ActiveConnectionName= "Con1"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "COURSE_ID"
Caption = "COURSE_ID"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "COURSE_NAME"
Caption = "COURSE_NAME"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "DESCRIPTION"
Caption = "DESCRIPTION"
EndProperty
BeginProperty Field4
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "SEMESTER"
Caption = "SEMESTER"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset8
CommandName = "rptallstudent"
CommDispId = 1048
RsDispId = 1055
CommandText = "select stud_id,name,nic_no,admit_date,address,phone from student"
ActiveConnectionName= "Con1"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 6
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "stud_id"
Caption = "stud_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "name"
Caption = "name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "nic_no"
Caption = "nic_no"
EndProperty
BeginProperty Field4
Precision = 16
Size = 16
Scale = 0
Type = 135
Name = "admit_date"
Caption = "admit_date"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "address"
Caption = "address"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 200
Name = "phone"
Caption = "phone"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset9
CommandName = "rptallvisitors"
CommDispId = 1056
RsDispId = 1061
CommandText = "select * from visitors"
ActiveConnectionName= "Con1"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 10
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "SR_NO"
Caption = "SR_NO"
EndProperty
BeginProperty Field2
Precision = 16
Size = 16
Scale = 0
Type = 135
Name = "DATE_VISIT"
Caption = "DATE_VISIT"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "NAME"
Caption = "NAME"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "FATHER_NAME"
Caption = "FATHER_NAME"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "QUALIFICATION"
Caption = "QUALIFICATION"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "CLASS_TIMING"
Caption = "CLASS_TIMING"
EndProperty
BeginProperty Field7
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "ADDRESS"
Caption = "ADDRESS"
EndProperty
BeginProperty Field8
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "REFERENCE"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -