Quản lý điểm sinh viên CNTT
177.560 lượt xem;
- QuanlydiemDataSet38.xsd
- Quản lý điểm sinh vien CNTT /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="QuanlydiemDataSet38" targetNamespace="http://tempuri.org/QuanlydiemDataSet38.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet38.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet38.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="QuanlydiemConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanlydiemConnectionString2 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanlydiemConnectionString2" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblKET_QUATableAdapter" GeneratorDataComponentClassName="tblKET_QUATableAdapter" Name="tblKET_QUA" UserDataComponentName="tblKET_QUATableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblKET_QUA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <InsertCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>INSERT INTO [dbo].[tblKET_QUA] ([MaSV], [HoTen], [MaLop], [TenMon], [DiemTB], [DiemThiLan1], [DiemTongKet], [HanhKiem], [HocKi], [GhiChu]) VALUES (@MaSV, @HoTen, @MaLop, @TenMon, @DiemTB, @DiemThiLan1, @DiemTongKet, @HanhKiem, @HocKi, @GhiChu)</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaSV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSV" SourceColumnNullMapping="false" SourceVersion="Current" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenMon" SourceColumnNullMapping="false" SourceVersion="Current" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemTB" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Current" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Current" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Current" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Current" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Current" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
27 </Parameters>
28 </DbCommand>
29 </InsertCommand>
30 <SelectCommand>
31 <DbCommand CommandType="Text" ModifiedByUser="false">
32 <CommandText>SELECT MaSV, HoTen, MaLop, TenMon, DiemTB, DiemThiLan1, DiemTongKet, HanhKiem, HocKi, GhiChu FROM dbo.tblKET_QUA</CommandText>
33 <Parameters />
34 </DbCommand>
35 </SelectCommand>
36 </DbSource>
37 </MainSource>
38 <Mappings>
39 <Mapping SourceColumn="MaSV" DataSetColumn="MaSV" />
40 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
41 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
42 <Mapping SourceColumn="TenMon" DataSetColumn="TenMon" />
43 <Mapping SourceColumn="DiemTB" DataSetColumn="DiemTB" />
44 <Mapping SourceColumn="DiemThiLan1" DataSetColumn="DiemThiLan1" />
45 <Mapping SourceColumn="DiemTongKet" DataSetColumn="DiemTongKet" />
46 <Mapping SourceColumn="HanhKiem" DataSetColumn="HanhKiem" />
47 <Mapping SourceColumn="HocKi" DataSetColumn="HocKi" />
48 <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
49 </Mappings>
50 <Sources />
51 </TableAdapter>
52 </Tables>
53 <Sources />
54 </DataSource>
55 </xs:appinfo>
56 </xs:annotation>
57 <xs:element name="QuanlydiemDataSet38" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet38" msprop:Generator_UserDSName="QuanlydiemDataSet38" msprop:EnableTableAdapterManager="True">
58 <xs:complexType>
59 <xs:choice minOccurs="0" maxOccurs="unbounded">
60 <xs:element name="tblKET_QUA" msprop:Generator_UserTableName="tblKET_QUA" msprop:Generator_RowDeletedName="tblKET_QUARowDeleted" msprop:Generator_TableClassName="tblKET_QUADataTable" msprop:Generator_RowChangedName="tblKET_QUARowChanged" msprop:Generator_RowClassName="tblKET_QUARow" msprop:Generator_RowChangingName="tblKET_QUARowChanging" msprop:Generator_RowEvArgName="tblKET_QUARowChangeEvent" msprop:Generator_RowEvHandlerName="tblKET_QUARowChangeEventHandler" msprop:Generator_TablePropName="tblKET_QUA" msprop:Generator_TableVarName="tabletblKET_QUA" msprop:Generator_RowDeletingName="tblKET_QUARowDeleting">
61 <xs:complexType>
62 <xs:sequence>
63 <xs:element name="MaSV" msprop:Generator_UserColumnName="MaSV" msprop:Generator_ColumnPropNameInRow="MaSV" msprop:Generator_ColumnVarNameInTable="columnMaSV" msprop:Generator_ColumnPropNameInTable="MaSVColumn">
64 <xs:simpleType>
65 <xs:restriction base="xs:string">
66 <xs:maxLength value="10" />
67 </xs:restriction>
68 </xs:simpleType>
69 </xs:element>
70 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
71 <xs:simpleType>
72 <xs:restriction base="xs:string">
73 <xs:maxLength value="30" />
74 </xs:restriction>
75 </xs:simpleType>
76 </xs:element>
77 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn" minOccurs="0">
78 <xs:simpleType>
79 <xs:restriction base="xs:string">
80 <xs:maxLength value="10" />
81 </xs:restriction>
82 </xs:simpleType>
83 </xs:element>
84 <xs:element name="TenMon" msprop:Generator_UserColumnName="TenMon" msprop:Generator_ColumnPropNameInRow="TenMon" msprop:Generator_ColumnVarNameInTable="columnTenMon" msprop:Generator_ColumnPropNameInTable="TenMonColumn" minOccurs="0">
85 <xs:simpleType>
86 <xs:restriction base="xs:string">
87 <xs:maxLength value="50" />
88 </xs:restriction>
89 </xs:simpleType>
90 </xs:element>
91 <xs:element name="DiemTB" msprop:Generator_UserColumnName="DiemTB" msprop:Generator_ColumnPropNameInRow="DiemTB" msprop:Generator_ColumnVarNameInTable="columnDiemTB" msprop:Generator_ColumnPropNameInTable="DiemTBColumn" type="xs:double" minOccurs="0" />
92 <xs:element name="DiemThiLan1" msprop:Generator_UserColumnName="DiemThiLan1" msprop:Generator_ColumnPropNameInRow="DiemThiLan1" msprop:Generator_ColumnVarNameInTable="columnDiemThiLan1" msprop:Generator_ColumnPropNameInTable="DiemThiLan1Column" type="xs:double" minOccurs="0" />
93 <xs:element name="DiemTongKet" msprop:Generator_UserColumnName="DiemTongKet" msprop:Generator_ColumnPropNameInRow="DiemTongKet" msprop:Generator_ColumnVarNameInTable="columnDiemTongKet" msprop:Generator_ColumnPropNameInTable="DiemTongKetColumn" type="xs:double" minOccurs="0" />
94 <xs:element name="HanhKiem" msprop:Generator_UserColumnName="HanhKiem" msprop:Generator_ColumnPropNameInRow="HanhKiem" msprop:Generator_ColumnVarNameInTable="columnHanhKiem" msprop:Generator_ColumnPropNameInTable="HanhKiemColumn" minOccurs="0">
95 <xs:simpleType>
96 <xs:restriction base="xs:string">
97 <xs:maxLength value="10" />
98 </xs:restriction>
99 </xs:simpleType>
100 </xs:element>
101 <xs:element name="HocKi" msprop:Generator_UserColumnName="HocKi" msprop:Generator_ColumnPropNameInRow="HocKi" msprop:Generator_ColumnVarNameInTable="columnHocKi" msprop:Generator_ColumnPropNameInTable="HocKiColumn" type="xs:int" minOccurs="0" />
102 <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
103 <xs:simpleType>
104 <xs:restriction base="xs:string">
105 <xs:maxLength value="200" />
106 </xs:restriction>
107 </xs:simpleType>
108 </xs:element>
109 </xs:sequence>
110 </xs:complexType>
111 </xs:element>
112 </xs:choice>
113 </xs:complexType>
114 </xs:element>
115 </xs:schema>
2 <xs:schema id="QuanlydiemDataSet38" targetNamespace="http://tempuri.org/QuanlydiemDataSet38.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet38.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet38.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="QuanlydiemConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanlydiemConnectionString2 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanlydiemConnectionString2" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblKET_QUATableAdapter" GeneratorDataComponentClassName="tblKET_QUATableAdapter" Name="tblKET_QUA" UserDataComponentName="tblKET_QUATableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblKET_QUA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <InsertCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>INSERT INTO [dbo].[tblKET_QUA] ([MaSV], [HoTen], [MaLop], [TenMon], [DiemTB], [DiemThiLan1], [DiemTongKet], [HanhKiem], [HocKi], [GhiChu]) VALUES (@MaSV, @HoTen, @MaLop, @TenMon, @DiemTB, @DiemThiLan1, @DiemTongKet, @HanhKiem, @HocKi, @GhiChu)</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaSV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSV" SourceColumnNullMapping="false" SourceVersion="Current" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenMon" SourceColumnNullMapping="false" SourceVersion="Current" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemTB" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Current" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Current" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Current" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Current" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Current" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
27 </Parameters>
28 </DbCommand>
29 </InsertCommand>
30 <SelectCommand>
31 <DbCommand CommandType="Text" ModifiedByUser="false">
32 <CommandText>SELECT MaSV, HoTen, MaLop, TenMon, DiemTB, DiemThiLan1, DiemTongKet, HanhKiem, HocKi, GhiChu FROM dbo.tblKET_QUA</CommandText>
33 <Parameters />
34 </DbCommand>
35 </SelectCommand>
36 </DbSource>
37 </MainSource>
38 <Mappings>
39 <Mapping SourceColumn="MaSV" DataSetColumn="MaSV" />
40 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
41 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
42 <Mapping SourceColumn="TenMon" DataSetColumn="TenMon" />
43 <Mapping SourceColumn="DiemTB" DataSetColumn="DiemTB" />
44 <Mapping SourceColumn="DiemThiLan1" DataSetColumn="DiemThiLan1" />
45 <Mapping SourceColumn="DiemTongKet" DataSetColumn="DiemTongKet" />
46 <Mapping SourceColumn="HanhKiem" DataSetColumn="HanhKiem" />
47 <Mapping SourceColumn="HocKi" DataSetColumn="HocKi" />
48 <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
49 </Mappings>
50 <Sources />
51 </TableAdapter>
52 </Tables>
53 <Sources />
54 </DataSource>
55 </xs:appinfo>
56 </xs:annotation>
57 <xs:element name="QuanlydiemDataSet38" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet38" msprop:Generator_UserDSName="QuanlydiemDataSet38" msprop:EnableTableAdapterManager="True">
58 <xs:complexType>
59 <xs:choice minOccurs="0" maxOccurs="unbounded">
60 <xs:element name="tblKET_QUA" msprop:Generator_UserTableName="tblKET_QUA" msprop:Generator_RowDeletedName="tblKET_QUARowDeleted" msprop:Generator_TableClassName="tblKET_QUADataTable" msprop:Generator_RowChangedName="tblKET_QUARowChanged" msprop:Generator_RowClassName="tblKET_QUARow" msprop:Generator_RowChangingName="tblKET_QUARowChanging" msprop:Generator_RowEvArgName="tblKET_QUARowChangeEvent" msprop:Generator_RowEvHandlerName="tblKET_QUARowChangeEventHandler" msprop:Generator_TablePropName="tblKET_QUA" msprop:Generator_TableVarName="tabletblKET_QUA" msprop:Generator_RowDeletingName="tblKET_QUARowDeleting">
61 <xs:complexType>
62 <xs:sequence>
63 <xs:element name="MaSV" msprop:Generator_UserColumnName="MaSV" msprop:Generator_ColumnPropNameInRow="MaSV" msprop:Generator_ColumnVarNameInTable="columnMaSV" msprop:Generator_ColumnPropNameInTable="MaSVColumn">
64 <xs:simpleType>
65 <xs:restriction base="xs:string">
66 <xs:maxLength value="10" />
67 </xs:restriction>
68 </xs:simpleType>
69 </xs:element>
70 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
71 <xs:simpleType>
72 <xs:restriction base="xs:string">
73 <xs:maxLength value="30" />
74 </xs:restriction>
75 </xs:simpleType>
76 </xs:element>
77 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn" minOccurs="0">
78 <xs:simpleType>
79 <xs:restriction base="xs:string">
80 <xs:maxLength value="10" />
81 </xs:restriction>
82 </xs:simpleType>
83 </xs:element>
84 <xs:element name="TenMon" msprop:Generator_UserColumnName="TenMon" msprop:Generator_ColumnPropNameInRow="TenMon" msprop:Generator_ColumnVarNameInTable="columnTenMon" msprop:Generator_ColumnPropNameInTable="TenMonColumn" minOccurs="0">
85 <xs:simpleType>
86 <xs:restriction base="xs:string">
87 <xs:maxLength value="50" />
88 </xs:restriction>
89 </xs:simpleType>
90 </xs:element>
91 <xs:element name="DiemTB" msprop:Generator_UserColumnName="DiemTB" msprop:Generator_ColumnPropNameInRow="DiemTB" msprop:Generator_ColumnVarNameInTable="columnDiemTB" msprop:Generator_ColumnPropNameInTable="DiemTBColumn" type="xs:double" minOccurs="0" />
92 <xs:element name="DiemThiLan1" msprop:Generator_UserColumnName="DiemThiLan1" msprop:Generator_ColumnPropNameInRow="DiemThiLan1" msprop:Generator_ColumnVarNameInTable="columnDiemThiLan1" msprop:Generator_ColumnPropNameInTable="DiemThiLan1Column" type="xs:double" minOccurs="0" />
93 <xs:element name="DiemTongKet" msprop:Generator_UserColumnName="DiemTongKet" msprop:Generator_ColumnPropNameInRow="DiemTongKet" msprop:Generator_ColumnVarNameInTable="columnDiemTongKet" msprop:Generator_ColumnPropNameInTable="DiemTongKetColumn" type="xs:double" minOccurs="0" />
94 <xs:element name="HanhKiem" msprop:Generator_UserColumnName="HanhKiem" msprop:Generator_ColumnPropNameInRow="HanhKiem" msprop:Generator_ColumnVarNameInTable="columnHanhKiem" msprop:Generator_ColumnPropNameInTable="HanhKiemColumn" minOccurs="0">
95 <xs:simpleType>
96 <xs:restriction base="xs:string">
97 <xs:maxLength value="10" />
98 </xs:restriction>
99 </xs:simpleType>
100 </xs:element>
101 <xs:element name="HocKi" msprop:Generator_UserColumnName="HocKi" msprop:Generator_ColumnPropNameInRow="HocKi" msprop:Generator_ColumnVarNameInTable="columnHocKi" msprop:Generator_ColumnPropNameInTable="HocKiColumn" type="xs:int" minOccurs="0" />
102 <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
103 <xs:simpleType>
104 <xs:restriction base="xs:string">
105 <xs:maxLength value="200" />
106 </xs:restriction>
107 </xs:simpleType>
108 </xs:element>
109 </xs:sequence>
110 </xs:complexType>
111 </xs:element>
112 </xs:choice>
113 </xs:complexType>
114 </xs:element>
115 </xs:schema>