Quản lý điểm sinh viên CNTT
180.062 lượt xem;
- QuanlydiemDataSet32.xsd
- Quản lý điểm sinh vien CNTT /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="QuanlydiemDataSet32" targetNamespace="http://tempuri.org/QuanlydiemDataSet32.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet32.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet32.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="tblKHOATableAdapter" GeneratorDataComponentClassName="tblKHOATableAdapter" Name="tblKHOA" UserDataComponentName="tblKHOATableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblKHOA" 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].[tblKHOA] WHERE (([MaKhoa] = @Original_MaKhoa) AND ((@IsNull_TenKhoa = 1 AND [TenKhoa] IS NULL) OR ([TenKhoa] = @Original_TenKhoa)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenKhoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
20 </Parameters>
21 </DbCommand>
22 </DeleteCommand>
23 <InsertCommand>
24 <DbCommand CommandType="Text" ModifiedByUser="false">
25 <CommandText>INSERT INTO [dbo].[tblKHOA] ([MaKhoa], [TenKhoa]) VALUES (@MaKhoa, @TenKhoa);
26 SELECT MaKhoa, TenKhoa FROM tblKHOA WHERE (MaKhoa = @MaKhoa)</CommandText>
27 <Parameters>
28 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
30 </Parameters>
31 </DbCommand>
32 </InsertCommand>
33 <SelectCommand>
34 <DbCommand CommandType="Text" ModifiedByUser="false">
35 <CommandText>SELECT MaKhoa, TenKhoa FROM dbo.tblKHOA</CommandText>
36 <Parameters />
37 </DbCommand>
38 </SelectCommand>
39 <UpdateCommand>
40 <DbCommand CommandType="Text" ModifiedByUser="false">
41 <CommandText>UPDATE [dbo].[tblKHOA] SET [MaKhoa] = @MaKhoa, [TenKhoa] = @TenKhoa WHERE (([MaKhoa] = @Original_MaKhoa) AND ((@IsNull_TenKhoa = 1 AND [TenKhoa] IS NULL) OR ([TenKhoa] = @Original_TenKhoa)));
42 SELECT MaKhoa, TenKhoa FROM tblKHOA WHERE (MaKhoa = @MaKhoa)</CommandText>
43 <Parameters>
44 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
45 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
46 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
47 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenKhoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="true" SourceVersion="Original" />
48 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
49 </Parameters>
50 </DbCommand>
51 </UpdateCommand>
52 </DbSource>
53 </MainSource>
54 <Mappings>
55 <Mapping SourceColumn="MaKhoa" DataSetColumn="MaKhoa" />
56 <Mapping SourceColumn="TenKhoa" DataSetColumn="TenKhoa" />
57 </Mappings>
58 <Sources />
59 </TableAdapter>
60 </Tables>
61 <Sources />
62 </DataSource>
63 </xs:appinfo>
64 </xs:annotation>
65 <xs:element name="QuanlydiemDataSet32" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet32" msprop:Generator_UserDSName="QuanlydiemDataSet32" msprop:EnableTableAdapterManager="True">
66 <xs:complexType>
67 <xs:choice minOccurs="0" maxOccurs="unbounded">
68 <xs:element name="tblKHOA" msprop:Generator_UserTableName="tblKHOA" msprop:Generator_RowDeletedName="tblKHOARowDeleted" msprop:Generator_TableClassName="tblKHOADataTable" msprop:Generator_RowChangedName="tblKHOARowChanged" msprop:Generator_RowClassName="tblKHOARow" msprop:Generator_RowChangingName="tblKHOARowChanging" msprop:Generator_RowEvArgName="tblKHOARowChangeEvent" msprop:Generator_RowEvHandlerName="tblKHOARowChangeEventHandler" msprop:Generator_TablePropName="tblKHOA" msprop:Generator_TableVarName="tabletblKHOA" msprop:Generator_RowDeletingName="tblKHOARowDeleting">
69 <xs:complexType>
70 <xs:sequence>
71 <xs:element name="MaKhoa" msprop:Generator_UserColumnName="MaKhoa" msprop:Generator_ColumnPropNameInRow="MaKhoa" msprop:Generator_ColumnVarNameInTable="columnMaKhoa" msprop:Generator_ColumnPropNameInTable="MaKhoaColumn">
72 <xs:simpleType>
73 <xs:restriction base="xs:string">
74 <xs:maxLength value="10" />
75 </xs:restriction>
76 </xs:simpleType>
77 </xs:element>
78 <xs:element name="TenKhoa" msprop:Generator_UserColumnName="TenKhoa" msprop:Generator_ColumnPropNameInRow="TenKhoa" msprop:Generator_ColumnVarNameInTable="columnTenKhoa" msprop:Generator_ColumnPropNameInTable="TenKhoaColumn" minOccurs="0">
79 <xs:simpleType>
80 <xs:restriction base="xs:string">
81 <xs:maxLength value="30" />
82 </xs:restriction>
83 </xs:simpleType>
84 </xs:element>
85 </xs:sequence>
86 </xs:complexType>
87 </xs:element>
88 </xs:choice>
89 </xs:complexType>
90 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
91 <xs:selector xpath=".//mstns:tblKHOA" />
92 <xs:field xpath="mstns:MaKhoa" />
93 </xs:unique>
94 </xs:element>
95 </xs:schema>
2 <xs:schema id="QuanlydiemDataSet32" targetNamespace="http://tempuri.org/QuanlydiemDataSet32.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet32.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet32.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="tblKHOATableAdapter" GeneratorDataComponentClassName="tblKHOATableAdapter" Name="tblKHOA" UserDataComponentName="tblKHOATableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblKHOA" 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].[tblKHOA] WHERE (([MaKhoa] = @Original_MaKhoa) AND ((@IsNull_TenKhoa = 1 AND [TenKhoa] IS NULL) OR ([TenKhoa] = @Original_TenKhoa)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenKhoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
20 </Parameters>
21 </DbCommand>
22 </DeleteCommand>
23 <InsertCommand>
24 <DbCommand CommandType="Text" ModifiedByUser="false">
25 <CommandText>INSERT INTO [dbo].[tblKHOA] ([MaKhoa], [TenKhoa]) VALUES (@MaKhoa, @TenKhoa);
26 SELECT MaKhoa, TenKhoa FROM tblKHOA WHERE (MaKhoa = @MaKhoa)</CommandText>
27 <Parameters>
28 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
30 </Parameters>
31 </DbCommand>
32 </InsertCommand>
33 <SelectCommand>
34 <DbCommand CommandType="Text" ModifiedByUser="false">
35 <CommandText>SELECT MaKhoa, TenKhoa FROM dbo.tblKHOA</CommandText>
36 <Parameters />
37 </DbCommand>
38 </SelectCommand>
39 <UpdateCommand>
40 <DbCommand CommandType="Text" ModifiedByUser="false">
41 <CommandText>UPDATE [dbo].[tblKHOA] SET [MaKhoa] = @MaKhoa, [TenKhoa] = @TenKhoa WHERE (([MaKhoa] = @Original_MaKhoa) AND ((@IsNull_TenKhoa = 1 AND [TenKhoa] IS NULL) OR ([TenKhoa] = @Original_TenKhoa)));
42 SELECT MaKhoa, TenKhoa FROM tblKHOA WHERE (MaKhoa = @MaKhoa)</CommandText>
43 <Parameters>
44 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
45 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
46 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
47 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenKhoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="true" SourceVersion="Original" />
48 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
49 </Parameters>
50 </DbCommand>
51 </UpdateCommand>
52 </DbSource>
53 </MainSource>
54 <Mappings>
55 <Mapping SourceColumn="MaKhoa" DataSetColumn="MaKhoa" />
56 <Mapping SourceColumn="TenKhoa" DataSetColumn="TenKhoa" />
57 </Mappings>
58 <Sources />
59 </TableAdapter>
60 </Tables>
61 <Sources />
62 </DataSource>
63 </xs:appinfo>
64 </xs:annotation>
65 <xs:element name="QuanlydiemDataSet32" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet32" msprop:Generator_UserDSName="QuanlydiemDataSet32" msprop:EnableTableAdapterManager="True">
66 <xs:complexType>
67 <xs:choice minOccurs="0" maxOccurs="unbounded">
68 <xs:element name="tblKHOA" msprop:Generator_UserTableName="tblKHOA" msprop:Generator_RowDeletedName="tblKHOARowDeleted" msprop:Generator_TableClassName="tblKHOADataTable" msprop:Generator_RowChangedName="tblKHOARowChanged" msprop:Generator_RowClassName="tblKHOARow" msprop:Generator_RowChangingName="tblKHOARowChanging" msprop:Generator_RowEvArgName="tblKHOARowChangeEvent" msprop:Generator_RowEvHandlerName="tblKHOARowChangeEventHandler" msprop:Generator_TablePropName="tblKHOA" msprop:Generator_TableVarName="tabletblKHOA" msprop:Generator_RowDeletingName="tblKHOARowDeleting">
69 <xs:complexType>
70 <xs:sequence>
71 <xs:element name="MaKhoa" msprop:Generator_UserColumnName="MaKhoa" msprop:Generator_ColumnPropNameInRow="MaKhoa" msprop:Generator_ColumnVarNameInTable="columnMaKhoa" msprop:Generator_ColumnPropNameInTable="MaKhoaColumn">
72 <xs:simpleType>
73 <xs:restriction base="xs:string">
74 <xs:maxLength value="10" />
75 </xs:restriction>
76 </xs:simpleType>
77 </xs:element>
78 <xs:element name="TenKhoa" msprop:Generator_UserColumnName="TenKhoa" msprop:Generator_ColumnPropNameInRow="TenKhoa" msprop:Generator_ColumnVarNameInTable="columnTenKhoa" msprop:Generator_ColumnPropNameInTable="TenKhoaColumn" minOccurs="0">
79 <xs:simpleType>
80 <xs:restriction base="xs:string">
81 <xs:maxLength value="30" />
82 </xs:restriction>
83 </xs:simpleType>
84 </xs:element>
85 </xs:sequence>
86 </xs:complexType>
87 </xs:element>
88 </xs:choice>
89 </xs:complexType>
90 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
91 <xs:selector xpath=".//mstns:tblKHOA" />
92 <xs:field xpath="mstns:MaKhoa" />
93 </xs:unique>
94 </xs:element>
95 </xs:schema>