1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id=
"QuanlydiemDataSet3" targetNamespace="http://tempuri.org/QuanlydiemDataSet31.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet31.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet31.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="QuanlydiemConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanlydiemConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanlydiemConnectionString" Provider="System.Data.SqlClient" />
8         </Connections>
9         <Tables>
10           <TableAdapter BaseClass=
"System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblSINH_VIENTableAdapter" GeneratorDataComponentClassName="tblSINH_VIENTableAdapter" Name="tblSINH_VIEN" UserDataComponentName="tblSINH_VIENTableAdapter">
11             <MainSource>
12               <DbSource ConnectionRef=
"QuanlydiemConnectionString (Settings)" DbObjectName="Quanlydiem.dbo.tblSINH_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].[tblSINH_VIEN] WHERE (([MaSv] = @Original_MaSv) AND ((@IsNull_HoTen =
1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_DiaChi = 1 AND [DiaChi] IS NULL) OR ([DiaChi] = @Original_DiaChi)) AND ([MaLop] = @Original_MaLop))</CommandText>
16                     <Parameters>
17                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Original" />
18                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HoTen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="true" SourceVersion="Original" />
19                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Original" />
20                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
21                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
22                       <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" />
23                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
24                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
25                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
26                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
27                     </Parameters>
28                   </DbCommand>
29                 </DeleteCommand>
30                 <InsertCommand>
31                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
32                     <CommandText>INSERT INTO [dbo].[tblSINH_VIEN] ([MaSv], [HoTen], [NgaySinh], [GioiTinh], [DiaChi], [MaLop]) VALUES (@MaSv, @HoTen, @NgaySinh, @GioiTinh, @DiaChi, @MaLop);
33 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
34                     <Parameters>
35                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
36                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
37                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
38                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
39                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
40                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
41                     </Parameters>
42                   </DbCommand>
43                 </InsertCommand>
44                 <SelectCommand>
45                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
46                     <CommandText>SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM dbo.tblSINH_VIEN</CommandText>
47                     <Parameters />
48                   </DbCommand>
49                 </SelectCommand>
50                 <UpdateCommand>
51                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
52                     <CommandText>UPDATE [dbo].[tblSINH_VIEN] SET [MaSv] = @MaSv, [HoTen] = @HoTen, [NgaySinh] = @NgaySinh, [GioiTinh] = @GioiTinh, [DiaChi] = @DiaChi, [MaLop] = @MaLop WHERE (([MaSv] = @Original_MaSv) AND ((@IsNull_HoTen =
1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_DiaChi = 1 AND [DiaChi] IS NULL) OR ([DiaChi] = @Original_DiaChi)) AND ([MaLop] = @Original_MaLop));
53 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
54                     <Parameters>
55                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
56                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
57                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
58                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
59                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
60                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
61                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Original" />
62                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HoTen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="true" SourceVersion="Original" />
63                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Original" />
64                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
65                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
66                       <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" />
67                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
68                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
69                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
70                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
71                     </Parameters>
72                   </DbCommand>
73                 </UpdateCommand>
74               </DbSource>
75             </MainSource>
76             <Mappings>
77               <Mapping SourceColumn=
"MaSv" DataSetColumn="MaSv" />
78               <Mapping SourceColumn=
"HoTen" DataSetColumn="HoTen" />
79               <Mapping SourceColumn=
"NgaySinh" DataSetColumn="NgaySinh" />
80               <Mapping SourceColumn=
"GioiTinh" DataSetColumn="GioiTinh" />
81               <Mapping SourceColumn=
"DiaChi" DataSetColumn="DiaChi" />
82               <Mapping SourceColumn=
"MaLop" DataSetColumn="MaLop" />
83             </Mappings>
84             <Sources />
85           </TableAdapter>
86         </Tables>
87         <Sources />
88       </DataSource>
89     </xs:appinfo>
90   </xs:annotation>
91   <xs:element name=
"QuanlydiemDataSet3" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet3" msprop:Generator_UserDSName="QuanlydiemDataSet3" msprop:EnableTableAdapterManager="True">
92     <xs:complexType>
93       <xs:choice minOccurs=
"0" maxOccurs="unbounded">
94         <xs:element name=
"tblSINH_VIEN" msprop:Generator_UserTableName="tblSINH_VIEN" msprop:Generator_RowDeletedName="tblSINH_VIENRowDeleted" msprop:Generator_TableClassName="tblSINH_VIENDataTable" msprop:Generator_RowChangedName="tblSINH_VIENRowChanged" msprop:Generator_RowClassName="tblSINH_VIENRow" msprop:Generator_RowChangingName="tblSINH_VIENRowChanging" msprop:Generator_RowEvArgName="tblSINH_VIENRowChangeEvent" msprop:Generator_RowEvHandlerName="tblSINH_VIENRowChangeEventHandler" msprop:Generator_TablePropName="tblSINH_VIEN" msprop:Generator_TableVarName="tabletblSINH_VIEN" msprop:Generator_RowDeletingName="tblSINH_VIENRowDeleting">
95           <xs:complexType>
96             <xs:sequence>
97               <xs:element name=
"MaSv" msprop:Generator_UserColumnName="MaSv" msprop:Generator_ColumnPropNameInRow="MaSv" msprop:Generator_ColumnVarNameInTable="columnMaSv" msprop:Generator_ColumnPropNameInTable="MaSvColumn">
98                 <xs:simpleType>
99                   <xs:restriction
base="xs:string">
100                     <xs:maxLength
value="50" />
101                   </xs:restriction>
102                 </xs:simpleType>
103               </xs:element>
104               <xs:element name=
"HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
105                 <xs:simpleType>
106                   <xs:restriction
base="xs:string">
107                     <xs:maxLength
value="50" />
108                   </xs:restriction>
109                 </xs:simpleType>
110               </xs:element>
111               <xs:element name=
"NgaySinh" msprop:Generator_UserColumnName="NgaySinh" msprop:Generator_ColumnPropNameInRow="NgaySinh" msprop:Generator_ColumnVarNameInTable="columnNgaySinh" msprop:Generator_ColumnPropNameInTable="NgaySinhColumn" minOccurs="0">
112                 <xs:simpleType>
113                   <xs:restriction
base="xs:string">
114                     <xs:maxLength
value="50" />
115                   </xs:restriction>
116                 </xs:simpleType>
117               </xs:element>
118               <xs:element name=
"GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" minOccurs="0">
119                 <xs:simpleType>
120                   <xs:restriction
base="xs:string">
121                     <xs:maxLength
value="50" />
122                   </xs:restriction>
123                 </xs:simpleType>
124               </xs:element>
125               <xs:element name=
"DiaChi" msprop:Generator_UserColumnName="DiaChi" msprop:Generator_ColumnPropNameInRow="DiaChi" msprop:Generator_ColumnVarNameInTable="columnDiaChi" msprop:Generator_ColumnPropNameInTable="DiaChiColumn" minOccurs="0">
126                 <xs:simpleType>
127                   <xs:restriction
base="xs:string">
128                     <xs:maxLength
value="50" />
129                   </xs:restriction>
130                 </xs:simpleType>
131               </xs:element>
132               <xs:element name=
"MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn">
133                 <xs:simpleType>
134                   <xs:restriction
base="xs:string">
135                     <xs:maxLength
value="5" />
136                   </xs:restriction>
137                 </xs:simpleType>
138               </xs:element>
139             </xs:sequence>
140           </xs:complexType>
141         </xs:element>
142       </xs:choice>
143     </xs:complexType>
144     <xs:unique name=
"Constraint1" msdata:PrimaryKey="true">
145       <xs:selector xpath=
".//mstns:tblSINH_VIEN" />
146       <xs:field xpath=
"mstns:MaSv" />
147     </xs:unique>
148   </xs:element>
149 </xs:schema>



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

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