Quản lý điểm sinh viên CNTT
180.111 lượt xem;
- QuanlydiemDataSet26.xsd
- Quản lý điểm sinh vien CNTT /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="QuanlydiemDataSet26" targetNamespace="http://tempuri.org/QuanlydiemDataSet26.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet26.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet26.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], [DiemThiLan2], [DiemTongKet], [HanhKiem], [HocKi], [GhiChu]) VALUES (@MaSV, @HoTen, @MaLop, @TenMon, @DiemTB, @DiemThiLan1, @DiemThiLan2, @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="@DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Current" />
24 <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" />
25 <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" />
26 <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" />
27 <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" />
28 </Parameters>
29 </DbCommand>
30 </InsertCommand>
31 <SelectCommand>
32 <DbCommand CommandType="Text" ModifiedByUser="false">
33 <CommandText>SELECT MaSV, HoTen, MaLop, TenMon, DiemTB, DiemThiLan1, DiemThiLan2, DiemTongKet, HanhKiem, HocKi, GhiChu FROM dbo.tblKET_QUA</CommandText>
34 <Parameters />
35 </DbCommand>
36 </SelectCommand>
37 </DbSource>
38 </MainSource>
39 <Mappings>
40 <Mapping SourceColumn="MaSV" DataSetColumn="MaSV" />
41 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
42 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
43 <Mapping SourceColumn="TenMon" DataSetColumn="TenMon" />
44 <Mapping SourceColumn="DiemTB" DataSetColumn="DiemTB" />
45 <Mapping SourceColumn="DiemThiLan1" DataSetColumn="DiemThiLan1" />
46 <Mapping SourceColumn="DiemThiLan2" DataSetColumn="DiemThiLan2" />
47 <Mapping SourceColumn="DiemTongKet" DataSetColumn="DiemTongKet" />
48 <Mapping SourceColumn="HanhKiem" DataSetColumn="HanhKiem" />
49 <Mapping SourceColumn="HocKi" DataSetColumn="HocKi" />
50 <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
51 </Mappings>
52 <Sources />
53 </TableAdapter>
54 </Tables>
55 <Sources />
56 </DataSource>
57 </xs:appinfo>
58 </xs:annotation>
59 <xs:element name="QuanlydiemDataSet26" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet26" msprop:Generator_UserDSName="QuanlydiemDataSet26" msprop:EnableTableAdapterManager="True">
60 <xs:complexType>
61 <xs:choice minOccurs="0" maxOccurs="unbounded">
62 <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">
63 <xs:complexType>
64 <xs:sequence>
65 <xs:element name="MaSV" msprop:Generator_UserColumnName="MaSV" msprop:Generator_ColumnPropNameInRow="MaSV" msprop:Generator_ColumnVarNameInTable="columnMaSV" msprop:Generator_ColumnPropNameInTable="MaSVColumn">
66 <xs:simpleType>
67 <xs:restriction base="xs:string">
68 <xs:maxLength value="10" />
69 </xs:restriction>
70 </xs:simpleType>
71 </xs:element>
72 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
73 <xs:simpleType>
74 <xs:restriction base="xs:string">
75 <xs:maxLength value="30" />
76 </xs:restriction>
77 </xs:simpleType>
78 </xs:element>
79 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn" minOccurs="0">
80 <xs:simpleType>
81 <xs:restriction base="xs:string">
82 <xs:maxLength value="10" />
83 </xs:restriction>
84 </xs:simpleType>
85 </xs:element>
86 <xs:element name="TenMon" msprop:Generator_UserColumnName="TenMon" msprop:Generator_ColumnPropNameInRow="TenMon" msprop:Generator_ColumnVarNameInTable="columnTenMon" msprop:Generator_ColumnPropNameInTable="TenMonColumn" minOccurs="0">
87 <xs:simpleType>
88 <xs:restriction base="xs:string">
89 <xs:maxLength value="50" />
90 </xs:restriction>
91 </xs:simpleType>
92 </xs:element>
93 <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" />
94 <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" />
95 <xs:element name="DiemThiLan2" msprop:Generator_UserColumnName="DiemThiLan2" msprop:Generator_ColumnPropNameInRow="DiemThiLan2" msprop:Generator_ColumnVarNameInTable="columnDiemThiLan2" msprop:Generator_ColumnPropNameInTable="DiemThiLan2Column" type="xs:double" minOccurs="0" />
96 <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" />
97 <xs:element name="HanhKiem" msprop:Generator_UserColumnName="HanhKiem" msprop:Generator_ColumnPropNameInRow="HanhKiem" msprop:Generator_ColumnVarNameInTable="columnHanhKiem" msprop:Generator_ColumnPropNameInTable="HanhKiemColumn" minOccurs="0">
98 <xs:simpleType>
99 <xs:restriction base="xs:string">
100 <xs:maxLength value="10" />
101 </xs:restriction>
102 </xs:simpleType>
103 </xs:element>
104 <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" />
105 <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
106 <xs:simpleType>
107 <xs:restriction base="xs:string">
108 <xs:maxLength value="200" />
109 </xs:restriction>
110 </xs:simpleType>
111 </xs:element>
112 </xs:sequence>
113 </xs:complexType>
114 </xs:element>
115 </xs:choice>
116 </xs:complexType>
117 </xs:element>
118 </xs:schema>
2 <xs:schema id="QuanlydiemDataSet26" targetNamespace="http://tempuri.org/QuanlydiemDataSet26.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet26.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet26.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], [DiemThiLan2], [DiemTongKet], [HanhKiem], [HocKi], [GhiChu]) VALUES (@MaSV, @HoTen, @MaLop, @TenMon, @DiemTB, @DiemThiLan1, @DiemThiLan2, @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="@DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Current" />
24 <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" />
25 <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" />
26 <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" />
27 <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" />
28 </Parameters>
29 </DbCommand>
30 </InsertCommand>
31 <SelectCommand>
32 <DbCommand CommandType="Text" ModifiedByUser="false">
33 <CommandText>SELECT MaSV, HoTen, MaLop, TenMon, DiemTB, DiemThiLan1, DiemThiLan2, DiemTongKet, HanhKiem, HocKi, GhiChu FROM dbo.tblKET_QUA</CommandText>
34 <Parameters />
35 </DbCommand>
36 </SelectCommand>
37 </DbSource>
38 </MainSource>
39 <Mappings>
40 <Mapping SourceColumn="MaSV" DataSetColumn="MaSV" />
41 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
42 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
43 <Mapping SourceColumn="TenMon" DataSetColumn="TenMon" />
44 <Mapping SourceColumn="DiemTB" DataSetColumn="DiemTB" />
45 <Mapping SourceColumn="DiemThiLan1" DataSetColumn="DiemThiLan1" />
46 <Mapping SourceColumn="DiemThiLan2" DataSetColumn="DiemThiLan2" />
47 <Mapping SourceColumn="DiemTongKet" DataSetColumn="DiemTongKet" />
48 <Mapping SourceColumn="HanhKiem" DataSetColumn="HanhKiem" />
49 <Mapping SourceColumn="HocKi" DataSetColumn="HocKi" />
50 <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
51 </Mappings>
52 <Sources />
53 </TableAdapter>
54 </Tables>
55 <Sources />
56 </DataSource>
57 </xs:appinfo>
58 </xs:annotation>
59 <xs:element name="QuanlydiemDataSet26" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet26" msprop:Generator_UserDSName="QuanlydiemDataSet26" msprop:EnableTableAdapterManager="True">
60 <xs:complexType>
61 <xs:choice minOccurs="0" maxOccurs="unbounded">
62 <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">
63 <xs:complexType>
64 <xs:sequence>
65 <xs:element name="MaSV" msprop:Generator_UserColumnName="MaSV" msprop:Generator_ColumnPropNameInRow="MaSV" msprop:Generator_ColumnVarNameInTable="columnMaSV" msprop:Generator_ColumnPropNameInTable="MaSVColumn">
66 <xs:simpleType>
67 <xs:restriction base="xs:string">
68 <xs:maxLength value="10" />
69 </xs:restriction>
70 </xs:simpleType>
71 </xs:element>
72 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
73 <xs:simpleType>
74 <xs:restriction base="xs:string">
75 <xs:maxLength value="30" />
76 </xs:restriction>
77 </xs:simpleType>
78 </xs:element>
79 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn" minOccurs="0">
80 <xs:simpleType>
81 <xs:restriction base="xs:string">
82 <xs:maxLength value="10" />
83 </xs:restriction>
84 </xs:simpleType>
85 </xs:element>
86 <xs:element name="TenMon" msprop:Generator_UserColumnName="TenMon" msprop:Generator_ColumnPropNameInRow="TenMon" msprop:Generator_ColumnVarNameInTable="columnTenMon" msprop:Generator_ColumnPropNameInTable="TenMonColumn" minOccurs="0">
87 <xs:simpleType>
88 <xs:restriction base="xs:string">
89 <xs:maxLength value="50" />
90 </xs:restriction>
91 </xs:simpleType>
92 </xs:element>
93 <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" />
94 <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" />
95 <xs:element name="DiemThiLan2" msprop:Generator_UserColumnName="DiemThiLan2" msprop:Generator_ColumnPropNameInRow="DiemThiLan2" msprop:Generator_ColumnVarNameInTable="columnDiemThiLan2" msprop:Generator_ColumnPropNameInTable="DiemThiLan2Column" type="xs:double" minOccurs="0" />
96 <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" />
97 <xs:element name="HanhKiem" msprop:Generator_UserColumnName="HanhKiem" msprop:Generator_ColumnPropNameInRow="HanhKiem" msprop:Generator_ColumnVarNameInTable="columnHanhKiem" msprop:Generator_ColumnPropNameInTable="HanhKiemColumn" minOccurs="0">
98 <xs:simpleType>
99 <xs:restriction base="xs:string">
100 <xs:maxLength value="10" />
101 </xs:restriction>
102 </xs:simpleType>
103 </xs:element>
104 <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" />
105 <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
106 <xs:simpleType>
107 <xs:restriction base="xs:string">
108 <xs:maxLength value="200" />
109 </xs:restriction>
110 </xs:simpleType>
111 </xs:element>
112 </xs:sequence>
113 </xs:complexType>
114 </xs:element>
115 </xs:choice>
116 </xs:complexType>
117 </xs:element>
118 </xs:schema>