Quản lý điểm sinh viên CNTT
177.553 lượt xem;
- QuanlydiemDataSet27.xsd
- Quản lý điểm sinh vien CNTT /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="QuanlydiemDataSet27" targetNamespace="http://tempuri.org/QuanlydiemDataSet27.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet27.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet27.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 <InsertCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>INSERT INTO [dbo].[tblKHOA] ([MaKhoa], [TenKhoa]) VALUES (@MaKhoa, @TenKhoa)</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
18 <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" />
19 </Parameters>
20 </DbCommand>
21 </InsertCommand>
22 <SelectCommand>
23 <DbCommand CommandType="Text" ModifiedByUser="false">
24 <CommandText>SELECT MaKhoa, TenKhoa FROM dbo.tblKHOA</CommandText>
25 <Parameters />
26 </DbCommand>
27 </SelectCommand>
28 </DbSource>
29 </MainSource>
30 <Mappings>
31 <Mapping SourceColumn="MaKhoa" DataSetColumn="MaKhoa" />
32 <Mapping SourceColumn="TenKhoa" DataSetColumn="TenKhoa" />
33 </Mappings>
34 <Sources />
35 </TableAdapter>
36 </Tables>
37 <Sources />
38 </DataSource>
39 </xs:appinfo>
40 </xs:annotation>
41 <xs:element name="QuanlydiemDataSet27" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet27" msprop:Generator_UserDSName="QuanlydiemDataSet27" msprop:EnableTableAdapterManager="True">
42 <xs:complexType>
43 <xs:choice minOccurs="0" maxOccurs="unbounded">
44 <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">
45 <xs:complexType>
46 <xs:sequence>
47 <xs:element name="MaKhoa" msprop:Generator_UserColumnName="MaKhoa" msprop:Generator_ColumnPropNameInRow="MaKhoa" msprop:Generator_ColumnVarNameInTable="columnMaKhoa" msprop:Generator_ColumnPropNameInTable="MaKhoaColumn" minOccurs="0">
48 <xs:simpleType>
49 <xs:restriction base="xs:string">
50 <xs:maxLength value="10" />
51 </xs:restriction>
52 </xs:simpleType>
53 </xs:element>
54 <xs:element name="TenKhoa" msprop:Generator_UserColumnName="TenKhoa" msprop:Generator_ColumnPropNameInRow="TenKhoa" msprop:Generator_ColumnVarNameInTable="columnTenKhoa" msprop:Generator_ColumnPropNameInTable="TenKhoaColumn" minOccurs="0">
55 <xs:simpleType>
56 <xs:restriction base="xs:string">
57 <xs:maxLength value="30" />
58 </xs:restriction>
59 </xs:simpleType>
60 </xs:element>
61 </xs:sequence>
62 </xs:complexType>
63 </xs:element>
64 </xs:choice>
65 </xs:complexType>
66 </xs:element>
67 </xs:schema>
2 <xs:schema id="QuanlydiemDataSet27" targetNamespace="http://tempuri.org/QuanlydiemDataSet27.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet27.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet27.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 <InsertCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>INSERT INTO [dbo].[tblKHOA] ([MaKhoa], [TenKhoa]) VALUES (@MaKhoa, @TenKhoa)</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
18 <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" />
19 </Parameters>
20 </DbCommand>
21 </InsertCommand>
22 <SelectCommand>
23 <DbCommand CommandType="Text" ModifiedByUser="false">
24 <CommandText>SELECT MaKhoa, TenKhoa FROM dbo.tblKHOA</CommandText>
25 <Parameters />
26 </DbCommand>
27 </SelectCommand>
28 </DbSource>
29 </MainSource>
30 <Mappings>
31 <Mapping SourceColumn="MaKhoa" DataSetColumn="MaKhoa" />
32 <Mapping SourceColumn="TenKhoa" DataSetColumn="TenKhoa" />
33 </Mappings>
34 <Sources />
35 </TableAdapter>
36 </Tables>
37 <Sources />
38 </DataSource>
39 </xs:appinfo>
40 </xs:annotation>
41 <xs:element name="QuanlydiemDataSet27" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet27" msprop:Generator_UserDSName="QuanlydiemDataSet27" msprop:EnableTableAdapterManager="True">
42 <xs:complexType>
43 <xs:choice minOccurs="0" maxOccurs="unbounded">
44 <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">
45 <xs:complexType>
46 <xs:sequence>
47 <xs:element name="MaKhoa" msprop:Generator_UserColumnName="MaKhoa" msprop:Generator_ColumnPropNameInRow="MaKhoa" msprop:Generator_ColumnVarNameInTable="columnMaKhoa" msprop:Generator_ColumnPropNameInTable="MaKhoaColumn" minOccurs="0">
48 <xs:simpleType>
49 <xs:restriction base="xs:string">
50 <xs:maxLength value="10" />
51 </xs:restriction>
52 </xs:simpleType>
53 </xs:element>
54 <xs:element name="TenKhoa" msprop:Generator_UserColumnName="TenKhoa" msprop:Generator_ColumnPropNameInRow="TenKhoa" msprop:Generator_ColumnVarNameInTable="columnTenKhoa" msprop:Generator_ColumnPropNameInTable="TenKhoaColumn" minOccurs="0">
55 <xs:simpleType>
56 <xs:restriction base="xs:string">
57 <xs:maxLength value="30" />
58 </xs:restriction>
59 </xs:simpleType>
60 </xs:element>
61 </xs:sequence>
62 </xs:complexType>
63 </xs:element>
64 </xs:choice>
65 </xs:complexType>
66 </xs:element>
67 </xs:schema>