1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id=
"QuanlydiemDataSet20" targetNamespace="http://tempuri.org/QuanlydiemDataSet20.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet20.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet20.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="tblGIANG_VIENTableAdapter" GeneratorDataComponentClassName="tblGIANG_VIENTableAdapter" Name="tblGIANG_VIEN" UserDataComponentName="tblGIANG_VIENTableAdapter">
11             <MainSource>
12               <DbSource ConnectionRef=
"QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblGIANG_VIEN" 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                 <DeleteCommand>
14                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
15                     <CommandText>DELETE FROM [dbo].[tblGIANG_VIEN] WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV =
1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)))</CommandText>
16                     <Parameters>
17                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Original" />
18                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="true" SourceVersion="Original" />
19                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Original" />
20                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
21                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
22                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
23                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
24                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
25                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
26                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhanLoaiGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="true" SourceVersion="Original" />
27                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Original" />
28                     </Parameters>
29                   </DbCommand>
30                 </DeleteCommand>
31                 <InsertCommand>
32                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
33                     <CommandText>INSERT INTO [dbo].[tblGIANG_VIEN] ([MaGV], [TenGV], [GioiTinh], [Phone], [Email], [PhanLoaiGV], [Anh]) VALUES (@MaGV, @TenGV, @GioiTinh, @Phone, @Email, @PhanLoaiGV, @Anh);
34 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)</CommandText>
35                     <Parameters>
36                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
37                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Current" />
38                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
39                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
40                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
41                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Current" />
42                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Anh" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Anh" SourceColumnNullMapping="false" SourceVersion="Current" />
43                     </Parameters>
44                   </DbCommand>
45                 </InsertCommand>
46                 <SelectCommand>
47                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
48                     <CommandText>SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM dbo.tblGIANG_VIEN</CommandText>
49                     <Parameters />
50                   </DbCommand>
51                 </SelectCommand>
52                 <UpdateCommand>
53                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
54                     <CommandText>UPDATE [dbo].[tblGIANG_VIEN] SET [MaGV] = @MaGV, [TenGV] = @TenGV, [GioiTinh] = @GioiTinh, [Phone] = @Phone, [Email] = @Email, [PhanLoaiGV] = @PhanLoaiGV, [Anh] = @Anh WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV =
1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)));
55 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)</CommandText>
56                     <Parameters>
57                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
58                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Current" />
59                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
60                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
61                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
62                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Current" />
63                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Anh" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Anh" SourceColumnNullMapping="false" SourceVersion="Current" />
64                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Original" />
65                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="true" SourceVersion="Original" />
66                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Original" />
67                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
68                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
69                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
70                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
71                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
72                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
73                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhanLoaiGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="true" SourceVersion="Original" />
74                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Original" />
75                     </Parameters>
76                   </DbCommand>
77                 </UpdateCommand>
78               </DbSource>
79             </MainSource>
80             <Mappings>
81               <Mapping SourceColumn=
"MaGV" DataSetColumn="MaGV" />
82               <Mapping SourceColumn=
"TenGV" DataSetColumn="TenGV" />
83               <Mapping SourceColumn=
"GioiTinh" DataSetColumn="GioiTinh" />
84               <Mapping SourceColumn=
"Phone" DataSetColumn="Phone" />
85               <Mapping SourceColumn=
"Email" DataSetColumn="Email" />
86               <Mapping SourceColumn=
"PhanLoaiGV" DataSetColumn="PhanLoaiGV" />
87               <Mapping SourceColumn=
"Anh" DataSetColumn="Anh" />
88             </Mappings>
89             <Sources />
90           </TableAdapter>
91         </Tables>
92         <Sources />
93       </DataSource>
94     </xs:appinfo>
95   </xs:annotation>
96   <xs:element name=
"QuanlydiemDataSet20" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet20" msprop:Generator_UserDSName="QuanlydiemDataSet20" msprop:EnableTableAdapterManager="True">
97     <xs:complexType>
98       <xs:choice minOccurs=
"0" maxOccurs="unbounded">
99         <xs:element name=
"tblGIANG_VIEN" msprop:Generator_UserTableName="tblGIANG_VIEN" msprop:Generator_RowDeletedName="tblGIANG_VIENRowDeleted" msprop:Generator_TableClassName="tblGIANG_VIENDataTable" msprop:Generator_RowChangedName="tblGIANG_VIENRowChanged" msprop:Generator_RowClassName="tblGIANG_VIENRow" msprop:Generator_RowChangingName="tblGIANG_VIENRowChanging" msprop:Generator_RowEvArgName="tblGIANG_VIENRowChangeEvent" msprop:Generator_RowEvHandlerName="tblGIANG_VIENRowChangeEventHandler" msprop:Generator_TablePropName="tblGIANG_VIEN" msprop:Generator_TableVarName="tabletblGIANG_VIEN" msprop:Generator_RowDeletingName="tblGIANG_VIENRowDeleting">
100           <xs:complexType>
101             <xs:sequence>
102               <xs:element name=
"MaGV" msprop:Generator_UserColumnName="MaGV" msprop:Generator_ColumnPropNameInRow="MaGV" msprop:Generator_ColumnVarNameInTable="columnMaGV" msprop:Generator_ColumnPropNameInTable="MaGVColumn">
103                 <xs:simpleType>
104                   <xs:restriction
base="xs:string">
105                     <xs:maxLength
value="10" />
106                   </xs:restriction>
107                 </xs:simpleType>
108               </xs:element>
109               <xs:element name=
"TenGV" msprop:Generator_UserColumnName="TenGV" msprop:Generator_ColumnPropNameInRow="TenGV" msprop:Generator_ColumnVarNameInTable="columnTenGV" msprop:Generator_ColumnPropNameInTable="TenGVColumn" minOccurs="0">
110                 <xs:simpleType>
111                   <xs:restriction
base="xs:string">
112                     <xs:maxLength
value="30" />
113                   </xs:restriction>
114                 </xs:simpleType>
115               </xs:element>
116               <xs:element name=
"GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" minOccurs="0">
117                 <xs:simpleType>
118                   <xs:restriction
base="xs:string">
119                     <xs:maxLength
value="10" />
120                   </xs:restriction>
121                 </xs:simpleType>
122               </xs:element>
123               <xs:element name=
"Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" minOccurs="0">
124                 <xs:simpleType>
125                   <xs:restriction
base="xs:string">
126                     <xs:maxLength
value="12" />
127                   </xs:restriction>
128                 </xs:simpleType>
129               </xs:element>
130               <xs:element name=
"Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
131                 <xs:simpleType>
132                   <xs:restriction
base="xs:string">
133                     <xs:maxLength
value="20" />
134                   </xs:restriction>
135                 </xs:simpleType>
136               </xs:element>
137               <xs:element name=
"PhanLoaiGV" msprop:Generator_UserColumnName="PhanLoaiGV" msprop:Generator_ColumnPropNameInRow="PhanLoaiGV" msprop:Generator_ColumnVarNameInTable="columnPhanLoaiGV" msprop:Generator_ColumnPropNameInTable="PhanLoaiGVColumn" minOccurs="0">
138                 <xs:simpleType>
139                   <xs:restriction
base="xs:string">
140                     <xs:maxLength
value="10" />
141                   </xs:restriction>
142                 </xs:simpleType>
143               </xs:element>
144               <xs:element name=
"Anh" msprop:Generator_UserColumnName="Anh" msprop:Generator_ColumnPropNameInRow="Anh" msprop:Generator_ColumnVarNameInTable="columnAnh" msprop:Generator_ColumnPropNameInTable="AnhColumn" type="xs:base64Binary" minOccurs="0" />
145             </xs:sequence>
146           </xs:complexType>
147         </xs:element>
148       </xs:choice>
149     </xs:complexType>
150     <xs:unique name=
"Constraint1" msdata:PrimaryKey="true">
151       <xs:selector xpath=
".//mstns:tblGIANG_VIEN" />
152       <xs:field xpath=
"mstns:MaGV" />
153     </xs:unique>
154   </xs:element>
155 </xs:schema>



Quản lý điểm sinh viên CNTT 180.091 lượt xem

Gõ tìm kiếm nhanh...