Hệ thống quản lý phòng tập trong C#
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="GymDataSet2" targetNamespace="http://tempuri.org/GymDataSet2.xsd" xmlns:mstns="http://tempuri.org/GymDataSet2.xsd" xmlns="http://tempuri.org/GymDataSet2.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="GymConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GymConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GymManagementSystem.Properties.Settings.GlobalReference.Default.GymConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="equipmentTableAdapter" GeneratorDataComponentClassName="equipmentTableAdapter" Name="equipment" UserDataComponentName="equipmentTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="GymConnectionString (Settings)" DbObjectName="dbo.equipment" 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=4.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].[equipment] ([name], [description], [used], [cost]) VALUES (@name, @description, @used, @cost)</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@used" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="used" SourceColumnNullMapping="false" SourceVersion="Current" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cost" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cost" SourceColumnNullMapping="false" SourceVersion="Current" />
21 </Parameters>
22 </DbCommand>
23 </InsertCommand>
24 <SelectCommand>
25 <DbCommand CommandType="Text" ModifiedByUser="false">
26 <CommandText>SELECT eqp_id, name, description, used, cost FROM dbo.equipment</CommandText>
27 <Parameters />
28 </DbCommand>
29 </SelectCommand>
30 </DbSource>
31 </MainSource>
32 <Mappings>
33 <Mapping SourceColumn="eqp_id" DataSetColumn="eqp_id" />
34 <Mapping SourceColumn="name" DataSetColumn="name" />
35 <Mapping SourceColumn="description" DataSetColumn="description" />
36 <Mapping SourceColumn="used" DataSetColumn="used" />
37 <Mapping SourceColumn="cost" DataSetColumn="cost" />
38 </Mappings>
39 <Sources />
40 </TableAdapter>
41 </Tables>
42 <Sources />
43 </DataSource>
44 </xs:appinfo>
45 </xs:annotation>
46 <xs:element name="GymDataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="GymDataSet2" msprop:Generator_UserDSName="GymDataSet2">
47 <xs:complexType>
48 <xs:choice minOccurs="0" maxOccurs="unbounded">
49 <xs:element name="equipment" msprop:Generator_TableClassName="equipmentDataTable" msprop:Generator_TableVarName="tableequipment" msprop:Generator_TablePropName="equipment" msprop:Generator_RowDeletingName="equipmentRowDeleting" msprop:Generator_RowChangingName="equipmentRowChanging" msprop:Generator_RowEvHandlerName="equipmentRowChangeEventHandler" msprop:Generator_RowDeletedName="equipmentRowDeleted" msprop:Generator_UserTableName="equipment" msprop:Generator_RowChangedName="equipmentRowChanged" msprop:Generator_RowEvArgName="equipmentRowChangeEvent" msprop:Generator_RowClassName="equipmentRow">
50 <xs:complexType>
51 <xs:sequence>
52 <xs:element name="eqp_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columneqp_id" msprop:Generator_ColumnPropNameInRow="eqp_id" msprop:Generator_ColumnPropNameInTable="eqp_idColumn" msprop:Generator_UserColumnName="eqp_id" type="xs:int" />
53 <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
54 <xs:simpleType>
55 <xs:restriction base="xs:string">
56 <xs:maxLength value="50" />
57 </xs:restriction>
58 </xs:simpleType>
59 </xs:element>
60 <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description" minOccurs="0">
61 <xs:simpleType>
62 <xs:restriction base="xs:string">
63 <xs:maxLength value="50" />
64 </xs:restriction>
65 </xs:simpleType>
66 </xs:element>
67 <xs:element name="used" msprop:Generator_ColumnVarNameInTable="columnused" msprop:Generator_ColumnPropNameInRow="used" msprop:Generator_ColumnPropNameInTable="usedColumn" msprop:Generator_UserColumnName="used" minOccurs="0">
68 <xs:simpleType>
69 <xs:restriction base="xs:string">
70 <xs:maxLength value="50" />
71 </xs:restriction>
72 </xs:simpleType>
73 </xs:element>
74 <xs:element name="cost" msprop:Generator_ColumnVarNameInTable="columncost" msprop:Generator_ColumnPropNameInRow="cost" msprop:Generator_ColumnPropNameInTable="costColumn" msprop:Generator_UserColumnName="cost" minOccurs="0">
75 <xs:simpleType>
76 <xs:restriction base="xs:string">
77 <xs:maxLength value="50" />
78 </xs:restriction>
79 </xs:simpleType>
80 </xs:element>
81 </xs:sequence>
82 </xs:complexType>
83 </xs:element>
84 </xs:choice>
85 </xs:complexType>
86 </xs:element>
87 </xs:schema>